fetch_data();
}
protected function fetch_data(){
// les data...
$this->cashdesk_list=array();
$rqt = "select * from cashdesk order by cashdesk_name";
$res = pmb_mysql_query($rqt);
$i=0;
if(pmb_mysql_num_rows($res)){
while($row = pmb_mysql_fetch_object($res)){
$this->cashdesk_list[$i]['id'] = $row->cashdesk_id;
$this->cashdesk_list[$i]['name'] = $row->cashdesk_name;
$i++;
}
}
}
public function get_form_summarize(){
global $msg;
global $cashdesk_list_form_summarize, $charset;
global $cashdesk_filter,$start_date, $stop_date;
if(!count($this->cashdesk_list))return "";
if(!$cashdesk_filter)$cashdesk_filter=array();
$selected = '';
if(!count($cashdesk_filter) )$selected= " selected=\"selected\" ";
$cashdesk_filter_form="";
$found=0;
$tt_realisee_no=0;
$tt_realisee=0;
$tt_encaissement_no=0;
$tt_encaissement=0;
$form = '';
$parity = 0;
foreach ($this->cashdesk_list as $index =>$cashdesk){
if(count($cashdesk_filter) ){
if(! in_array($cashdesk['id'], $cashdesk_filter)) continue;
}
$cashdesk_info=new cashdesk($cashdesk['id']);
$all_transactions=$cashdesk_info->summarize($start_date, $stop_date, 0, 0);
foreach($all_transactions as $transactions){
if ($parity++ % 2) $pair_impair = "even"; else $pair_impair = "odd";
$form.= "
| ".htmlentities($cashdesk['name'],ENT_QUOTES, $charset)." |
".htmlentities($transactions['name'],ENT_QUOTES, $charset)." |
".htmlentities($this->format_price($transactions['unit_price']),ENT_QUOTES, $charset)." |
".htmlentities($this->format_price($transactions['montant']),ENT_QUOTES, $charset)." |
".htmlentities($this->format_price($transactions['realisee_no']),ENT_QUOTES, $charset)." |
".htmlentities($this->format_price($transactions['realisee']),ENT_QUOTES, $charset)." |
".htmlentities($this->format_price($transactions['encaissement_no']),ENT_QUOTES, $charset)." |
".htmlentities($this->format_price($transactions['encaissement']),ENT_QUOTES, $charset) . $this->get_display_payment_method($transactions['encaissement_payment_method']) . " |
";
$tt_realisee_no+=$transactions['realisee_no'];
$tt_realisee+=$transactions['realisee'];
$tt_encaissement_no+=$transactions['encaissement_no'];
$tt_encaissement+=$transactions['encaissement'];
$found++;
}
}
$formall=str_replace('!!cashdesk_list!!', $form, $cashdesk_list_form_summarize);
$formall=str_replace('!!cashdesk_filter!!', $cashdesk_filter_form, $formall);
$formall=str_replace('!!start_date!!', get_input_date('start_date', 'start_date', $start_date), $formall);
$formall=str_replace('!!stop_date!!', get_input_date('stop_date', 'stop_date', $stop_date), $formall);
$formall=str_replace('!!realisee_no!!',$this->format_price($tt_realisee_no) , $formall);
$formall=str_replace('!!realisee!!',$this->format_price($tt_realisee) , $formall);
$formall=str_replace('!!encaissement_no!!',$this->format_price($tt_encaissement_no) , $formall);
$formall=str_replace('!!encaissement!!',$this->format_price($tt_encaissement) , $formall);
$formall=str_replace('!!transaction_filter!!', '', $formall);
return $formall;
}
public function get_display_payment_method($encaissement_payment_method, $for_excel=0) {
$display = '';
$data = array();
foreach ($encaissement_payment_method as $transaction) {
if ($transaction['transaction_payment_method_name'] && $transaction['cash']) {
if(!isset($data[$transaction['transaction_payment_method_name']])) {
$data[$transaction['transaction_payment_method_name']] = 0;
}
$data[$transaction['transaction_payment_method_name']]+= $transaction['cash'];
}
}
foreach ($data as $mode => $montant) {
if($for_excel) {
if ($display) {
$display.= '; ';
}
$display.= $mode . ': ' . $this->format_price($montant);
} else {
if (!$display) {
$display.= '
';
} else {
$display.= '; ';
}
$display.= $mode . ': ' . $this->format_price($montant);
}
}
return $display;
}
public function get_html_summarize(){
global $msg;
global $charset,$cashdesk_list_form_summarize_table,$titre_page;
global $cashdesk_filter,$start_date, $stop_date;
if(!count($this->cashdesk_list))return "";
if(!$cashdesk_filter)$cashdesk_filter=array();
if(!$cashdesk_filter[0])$cashdesk_filter=array();
$found=0;
$tt_realisee_no=0;
$tt_realisee=0;
$tt_encaissement_no=0;
$tt_encaissement=0;
$form = '';
foreach ($this->cashdesk_list as $index =>$cashdesk){
if(count($cashdesk_filter) ){
if(! in_array($cashdesk['id'], $cashdesk_filter)) continue;
}
$cashdesk_info=new cashdesk($cashdesk['id']);
$all_transactions=$cashdesk_info->summarize($start_date, $stop_date, 0, 0);
foreach($all_transactions as $transactions){
$form.= "
| ".htmlentities($cashdesk['name'],ENT_QUOTES, $charset)." |
".htmlentities($transactions['name'],ENT_QUOTES, $charset)." |
".htmlentities($this->format_price($transactions['unit_price']),ENT_QUOTES, $charset)." |
".htmlentities($this->format_price($transactions['montant']),ENT_QUOTES, $charset)." |
".htmlentities($this->format_price($transactions['realisee_no']),ENT_QUOTES, $charset)." |
".htmlentities($this->format_price($transactions['realisee']),ENT_QUOTES, $charset)." |
".htmlentities($this->format_price($transactions['encaissement_no']),ENT_QUOTES, $charset)." |
".htmlentities($this->format_price($transactions['encaissement']),ENT_QUOTES, $charset) . $this->get_display_payment_method($transactions['encaissement_payment_method']) . " |
";
$tt_realisee_no+=$transactions['realisee_no'];
$tt_realisee+=$transactions['realisee'];
$tt_encaissement_no+=$transactions['encaissement_no'];
$tt_encaissement+=$transactions['encaissement'];
$found++;
}
}
$formall=str_replace('!!cashdesk_list!!', $form, $cashdesk_list_form_summarize_table);
$formall=str_replace('!!realisee_no!!',$this->format_price($tt_realisee_no) , $formall);
$formall=str_replace('!!realisee!!',$this->format_price($tt_realisee) , $formall);
$formall=str_replace('!!encaissement_no!!',$this->format_price($tt_encaissement_no) , $formall);
$formall=str_replace('!!encaissement!!',$this->format_price($tt_encaissement) , $formall);
return $formall;
}
public function get_excel_summarize(){
global $msg, $class_path;
global $charset,$fichier_temp_nom,$titre_page;
global $cashdesk_filter,$start_date, $stop_date;
if(!count($this->cashdesk_list))return "";
if(!$cashdesk_filter)$cashdesk_filter=array();
if(!$cashdesk_filter[0])$cashdesk_filter=array();
require_once ($class_path."/spreadsheetPMB.class.php");
$worksheet = new spreadsheetPMB();
$worksheet->write(0,0,$titre_page);
$i=2;
$j=2;
$worksheet->write($i,$j++,$msg["cashdesk_edition_name"]);
$worksheet->write($i,$j++,$msg["cashdesk_edition_transac_name"]);
$worksheet->write($i,$j++,$msg["cashdesk_edition_transac_unit_price"]);
$worksheet->write($i,$j++,$msg["cashdesk_edition_transac_montant"]);
$worksheet->write($i,$j++,$msg["cashdesk_edition_transac_realisee_no"]);
$worksheet->write($i,$j++,$msg["cashdesk_edition_transac_realisee"]);
$worksheet->write($i,$j++,$msg["cashdesk_edition_transac_encaissement_no"]);
$worksheet->write($i,$j++,$msg["cashdesk_edition_transac_encaissement"]);
$worksheet->write($i,$j++,$msg["cashdesk_edition_transac_payment_method"]);
$i++;
foreach ($this->cashdesk_list as $index =>$cashdesk){
if(count($cashdesk_filter) ){
if(! in_array($cashdesk['id'], $cashdesk_filter)) continue;
}
$cashdesk_info=new cashdesk($cashdesk['id']);
$all_transactions=$cashdesk_info->summarize($start_date, $stop_date, 0, 0);
if(!count($all_transactions) ) continue;
foreach($all_transactions as $transactions){
$j=2;
$worksheet->write($i,$j++,$cashdesk['name']);
$worksheet->write($i,$j++,$transactions['name']);
$worksheet->write($i,$j++,$this->format_price($transactions['unit_price']));
$worksheet->write($i,$j++,$this->format_price($transactions['montant']));
$worksheet->write($i,$j++,$this->format_price($transactions['realisee_no']));
$worksheet->write($i,$j++,$this->format_price($transactions['realisee']));
$worksheet->write($i,$j++,$this->format_price($transactions['encaissement_no']));
$worksheet->write($i,$j++,$this->format_price($transactions['encaissement']));
$worksheet->write($i,$j++,$this->get_display_payment_method($transactions['encaissement_payment_method'], 1) );
$i++;
}
}
$worksheet->download('caisse.xls');
}
public function format_price($price) {
global $pmb_fine_precision;
if (!$pmb_fine_precision) $pmb_fine_precision=2;
return number_format(floatval($price), $pmb_fine_precision, '.', ' ');
}
}