";
$rs->reset();
if ($width_col)
{
$td_tag_width=" width:".$width_col."px;";
}
/*
else
{
$td_tag_width=" width='".floor(100/$width)."%'";
}
*/
unset($arr_checked);
if(is_array($param1['arr_checked']))
$arr_checked=$param1['arr_checked'];
elseif($param1['sql_checked'])
$arr_checked=msc($param1['sql_checked']);
elseif($param1['set_checked'])
$arr_checked=explode(",",$param1['set_checked']);
$columnas_impresas=0;
while($rs->next())
{
if($columnas_impresas==$width)
{
//$out.="
";
$columnas_impresas=0;
}
$out.="";
$columnas_impresas++;
}//end while
$out.="";
return $out;
}//end cb_div
}//end class
?>res=msq($q);
}
}//end constructor
function next(){
if(isset($this->res))
if($this->row=mysql_fetch_array($this->res))
{
$this->current++;
return true;
}
else
return false;
}//end function next
function nrows(){
return @mysql_num_rows($this->res);
}
function pages(){
if(!isset($this->pages))
$this->pages=ceil($this->nrows()/$this->page_size);
return $this->pages;
}
function reset(){
unset($this->row);
return @mysql_data_seek($this->res,0);
}
function current(){
return $this->current;
}
function moveto($pos){
$this->reset();
for($i=0;$i<$pos;$i++)
$this->next();
}//end moveto
//Handy function which brings the value of the field $field,
//from the row which meets the conditions specified as a query string
function find($field, $qs_where)
{
$arr_eq=explode("&",$qs_where);
$original_pos=$this->current();
foreach($arr_eq as $eq)
{
list($key,$value)=explode("=",$eq);
$arr_kv[$key]=$value;
}
$this->reset();
while($this->next())
{
$found=true;
foreach($arr_kv as $key=>$value)
{
if($this->row[$key]!=$value)
$found=false;
}//end foreach $arr_kv
if($found)
{
$ret=$this->row[$field];
$this->moveto($original_pos);
return $ret;
}
}//end while
$this->moveto($original_pos);
return false;
}//end find();
///////////////////////////
// PAGING
///////////////////////////
function paging($param=NULL){
$wing=4; //how many numbers a the side of the shown page display
$shown; //shown page (pag)
$pp; //printed page - current: page inside the paging loop
$pp_last; //printed page number (last)
$page_size =$param['page_size'];
$sep =$param['sep'];
//param['omit'] //no arrastrar estos valores en el query string
if(!$sep)
$sep=" | ";
if(!$page_size)
{
$page_size=$this->page_size;
}
if(!$page_size)
{
trigger_error("rs::paging: No se pudo determinar page_size",E_USER_WARNING);
return;
}
$shown=$_REQUEST['pag'];
if(!$shown)
$shown=1;
/*if($shown<=1)
{
$_SESSION['SES_filtro']=$_POST;
}
d($_SESSION['SES_filtro']);*/
//npages
$npages=ceil($this->nrows()/$page_size);
//pp_first:
$pp_first=($shown)-($wing);
if($pp_first < 1)
$pp_first=1;
//pp_last:
$pp_last=$shown+$wing;
if($pp_last > $npages)
$pp_last=$npages;
//////////////
//Armar HTML
/////////////
unset($out);
//Imprimir "anterior":
if($shown >1 and $pp_first>1)
$out.="<< ";
$first=true;
//Imprimir numeros
for($i=$pp_first; $i<= $pp_last; $i++)
{
if(!$first)
$out.= $sep;
else
$first=false;
if($i!=$shown)
$out.= " ".$i." ";
else
$out.= " $i >> ";
return $out;
}//end paging()
function paging_pd(){
//PAGING-----------------------
//Mostrar paging?
$out= 'pages<=1)
$out.= "disabled";
$out.= ' name="select" class="sys" onChange="cambiar_pagina(this.value)>';
for($i=1;$i<$this->page_size();$i++)
$out.= "$i/".$this->pages()." ";
$page_num=1;
$pos=0;
/*
$do=true;
while($do)
{
if($pos < $nrows)
mysql_data_seek($res,$pos);
$row=fah($res);
$head=strtoupper(substr($row['nombre'],0,3));
if(!$head)
$head="...";
$pos+=PAGE_SIZE;
if($pos >= $nrows)
{
$pos=$nrows;
$do=false;
}
if($pos-1 < $nrows)
mysql_data_seek($res,$pos-1);//el anterior tomamos para la cola
$row=fah($res);
$tail=strtoupper(substr($row['nombre'],0,3));
if(!$tail)
$tail="...";
echo "$page_num ($head - $tail) ";
$page_num++;
}
?>
";
return $out;
}//end paging_pd()
////////////////////////////////
//FUNCIONES UTILES
////////////////////////////////
//Sirve para alertar de que el field no fue traido
function rqf($field){
if(!@in_array($field,array_keys($this->row)))
{
$a=debug_backtrace();
$last=count($a)-1;
echo ("Notice: RQF: ('".$a[$last]['file']."' LINE ".$a[$last]['line'].") '$field ' is not a field in row");
}
}
////////////////////////
//TAGS (standard)
////////////////////////
function id(){
return $this->row['id'];
}
function nombre(){
return $this->row['nombre'];
}
///////////////////////////////
// SQL (standard)
///////////////////////////////
function select_all(){
$this->res=msq("
SELECT
id,nombre
FROM ".get_class($this)."
ORDER BY nombre");
}//end select_all()
}//end class
?>currency = $currency;
$this->amount = $amount;
}//end constructor
}//end class price_part
class price{
//var $amount;
//var $currency; //id of currency
var $parts=array();
function price($currency=NULL,$amount=NULL)
{
//Add part to the parts array (only if $amount != 0)
if($amount>0)
$this->parts[]=new price_part($currency,$amount);
}
function ncurrency($currency)
{
if(!isset($GLOBALS['currencies']))
{
$res=msq("SELECT id,nombre FROM monedas ORDER BY orden");
while($row=mysql_fetch_array($res))
{
$GLOBALS['currencies'][$row['id']]=$row['nombre'];
}
}//end if!currencies
return($GLOBALS['currencies'][$currency]);
}//end function ncurrency
/////////////////////////////////////////////////////////
//
//function Convert_price($price_src,$currency_dest){
//
/////////////////////////////////////////////////////////
//
//Converts currency of all parts of the price to the desired one
//if possible. It also merges (sums) parts with same currency
//
//////////////////////////////////////////////////////////
function convert($arg1,$arg2=NULL){
if($arg2===NULL)
{
$currency_dest=$arg1;
$price= $this; //Note: this does not modify the current instance (use & if wanted)
}
else
{
$currency_dest=$arg2;
$price=$arg1;
}
if(!$currency_dest)
return $price;
if(count($price->parts))
foreach($price->parts as $key=>$part)
{
$currency_src =$part->currency;
$amount_src =$part->amount;
//Calculate relation between src and dest currencies
$relation=msv("SELECT
# invertimos la relacion según como se halla guardado
IF(moneda_unidad='$currency_src',
relacion
,
IF(relacion!=0,1/relacion,0)
) AS relacion
FROM cotizaciones
WHERE
(moneda_unidad='$currency_src' AND moneda_en='$currency_dest')
OR
(moneda_unidad='$currency_dest' AND moneda_en='$currency_src')
ORDER BY cotizaciones.fecha DESC, cotizaciones.id
LIMIT 1");
if(!$relation)
{
//if not relation found, return the same value
$price->parts[$key]=$part;
}
else
{
$price->parts[$key]->amount = round($amount_src*$relation,2);
$price->parts[$key]->currency=$currency_dest;
}
}//end foreach part
//Now MERGE all parts with the same currency
//TO-DO
$merged=new price();
foreach($price->parts as $part)
$merged->sum($part->currency,$part->amount);
///////
return $merged;
}//end function convert_price()
function play_conv_clean($currency,$amount){
$price=new price($currency,$amount);
price::play(price::convert_price($price,price::get_user_currency()));
}//end function
//obsolete(for compatibility)
function _play($price){
price::to_string($price);
}
function to_string($price=NULL){
if($price==NULL)
$price=$this;
$free=true;
$plus=false;
if(count($price->parts))
foreach($price->parts as $part)
{
if($plus)
$out.= " + ";
else
$plus=true;
$out.= price::ncurrency($part->currency)." ".price::amount_dash($part->amount);
if($part->amount!=0)
$free=false;
}
/*if($free)
return "FREE";
else*/
return $out;
}//end function play
/////////////////////////////////////////////////////////////////////
//Converts to the user currency returns the string representation of price
/////////////////////////////////////////////////////////////////////
function to_string_conv($currency=NULL,$amount=NULL){
if($currency!==NULL)
$price=new price($currency,$amount);
else
$price=$this;
$price=$price->convert(price::get_user_currency());
return $price->to_string();
}//end function
function play($price){
echo price::_play($price);
}
//amount processing
function amount_dash($amount){
$amount=round($amount,2);
if(substr($amount,-3)===".00")
return substr($amount,0,-3).".-";
else
return $amount;
}//end function play_dash
function amount_clean($amount){
$amount=round($amount,2);
if(substr($amount,-3)===".00")
return substr($amount,0,-3).".-";
else
return $amount;
}//end function
function get_user_currency(){
return $_SESSION['SES_moneda'];
}//end function get user currency
function sum($currency,$amount){
if($amount) //only add part if $amount !=0
{
if(is_array($this->parts))
foreach($this->parts as $key=>$part)
{
if($part->currency==$currency)
{
$this->parts[$key]->amount+=$amount;
return;
}
}
//If there was no currency match in any part, add the part
$this->parts[]=new price_part($currency,$amount);
}
}//end function sum
// (*) multiplication sign overloading (only works with a scalar)
function by($factor){
$price=$this;
if(is_array($price->parts))
foreach($price->parts as $key=>$part)
$price->parts[$key]->amount*=$factor;
return $price;
}//end function sum
// (+) plus sign overloading
function plus($plus){
$price=$this;
if(is_array($plus->parts))
foreach($plus->parts as $key_plus=>$part_plus)
{
$part_added=false;
if(is_array($price->parts))
foreach($price->parts as $key=>$part)
{
if($part->currency==$part_plus->currency)
{
$price->parts[$key]->amount+=$part_plus->amount;
$part_added=true;
}
}
if(!$part_added)
{
//If there was no currency match in any part, add the part
$price->parts[]=$part_plus;
}
}//end loop for each added part
return $price;
}//end function plus
}//end class price/////////////////////////////
}//ENDIFNDEF
?>res=msq("SELECT
usuarios.id AS v,
CONCAT(apellido,',',nombre) AS t
FROM usuarios
$sql_where
GROUP BY usuarios.id
ORDER BY apellido,nombre"); */
}//end load_items
}//end class msctr_usuarios
?>name=$name;
$this->value=$value;
}//end constructor
function play(){
static $function_calendar_update;//valvula para poner solo una vez la funcion de javascript
list($anio,$mes,$dia)=explode("-",$this->value);
?>
Día:
...
$i";
}
?>
Mes:
...
" >
Año:
... $i";
}
?>
name=$name;
$this->value=$value;
}//end constructor
function play(){
static $function_time_update;//valvula para poner solo una vez la funcion de javascript
list($h,$m,$s)=explode(":",$this->value); //solo se usa h y m
if(!$function_time_update===true)
{
$function_time_update=true;
?>
".str_pad($i,2,0,STR_PAD_LEFT)."";
}
?>
:
>
name=$_name;
$this->value=$_value;
}//end constructor
function play($_name=NULL,$_value=NULL)
{
if($_name)
{
$name=$_name;
$this->name=$_name;
}
else
$name=$this->name;
if($_value)
$value=$_value;
else
$value=$this->value;
?>
display_thumbs($this->value,$this->own_descriptions)?>
Día:
...
$i";
}
?>
Mes:
...
" >
Año:
... $i";
}
?>
name=$_name;
$this->value=$_value;
$this->nota=$_nota;
}//end constructor
function play($_name=NULL,$_value=NULL)
{
if($_name)
{
$name=$_name;
$this->name=$_name;
}
else
$name=$this->name;
if($_value)
$value=$_value;
else
$value=$this->value;
if($this->rstring)
$rstring=$this->rstring;
else
$rstring=SYSTEM_RSTRING;//use system default resize string
?>
*/?>
display_thumbs($this->value,$this->own_descriptions); //AGREGADO POR PABLO ?>
".$row['archivo']." "; //Imprime Nombre de archivo
?>