setDb($db); $p->setIdProcess($var); $dataResto = $p->getDatosMaster(); $cont_arr = count($dataResto); $resultado=""; $i=1; $subtotal =0; $ttax=0; $total=0; $totalpay_c=0; $tot_setup = 0; foreach($dataResto as $data){ $t_orders= $data['orders']+$data['call2min']; $calls=($data['call2min']==0) ? 'n/a':$data['call2min']; //Payment Method: XXXXX ( OSEA pones Credit Card O Pre Authorized Deposit ) //2) Payment will be processed between the 15th and 17th of the month $type_pay=""; $type_pay = $data['type_pay']; $s_typepay ="NO"; if (($type_pay=="1") || ($type_pay=="2")) { $s_typepay ="Credit-Cheque"; } $subtotal = $subtotal+number_format($data['sub_total'],2); $ttax = $ttax+number_format($data['tax1'],2)+number_format($data['tax2'],2); $total = $total+number_format(($data['totalpay']),2); if($data['type_pay']=="1"){ $totalpay_c = $totalpay_c+number_format(($data['sub_total']),2); } if($data['type_pay']=="2"){ $totalpay_c = $totalpay_c+number_format(($data['sub_total']),2); } $eemail = ( $data['mail_invoice']=="0" ? ' Email ':'' ); $semail = ( $data['mail_invoice']=="0" ? $data['resto_mail']:'' ); $folderemail = ( $data['mail_invoice']=="0" ? 'email/':'correo/' ); $fol_process =$var."/"; $end_trial=''; $end_trial_s = ""; if ( $data['end_trial']=="0") { $end_trial_s = ""; } if ( $data['end_trial']=="1") { $end_trial_s = "set_up/"; } if ( $data['end_trial']=="2") { $end_trial_s = "trial/"; } if ($data['end_trial']==1) { $end_trial='Sep up'; $tot_setup = $tot_setup + $data['sub_total']; } if ($data['end_trial']==2) { $end_trial='Trial'; $tot_setup = $tot_setup + $data['sub_total']; } $qty_orders = 0; $qty_orders = $data['qty_ord'] + $data['qty_call']; if(is_numeric($qty_orders)){ } else { $qty_orders =0; } $idprevious = $var -1; $idresto = 0; $idbranchs = 0; $qty_previous = 0; $invoice_previous=0; $idresto = $data['idresto']; $idbranchs = $data['idbranch']; $previousMonth1 =''; $previousMonth1 = $p->previousMonth($idprevious,$idresto, $idbranchs); $data1=""; foreach($previousMonth1 as $data1) { $qty_previous = $data1['total_order']; $invoice_previous = $data1['total_invoice']; //qty_ord, qty_call $p_qty_ord = $data1['qty_ord']; $p_qty_call = $data1['qty_call']; } $s_qty_orders =''; $s_orders = ''; $s_call2min = ''; $s_orders = $data['orders']; $s_call2min = $data['call2min']; if ($qty_orders == 0) { //orders call2min $s_qty_orders = ' '.$qty_orders.''; } else { if ($qty_orders > $qty_previous) { $s_qty_orders = ' '.$qty_orders.''; } else { if ($qty_orders < $qty_previous) { $s_qty_orders = ' '.$qty_orders.''; } else { $s_qty_orders = ' '.$qty_orders.''; } } } //Monto $totalpay = 0; $totalpay = $data['totalpay']; $s_totalpay = ''; if ($totalpay == 0) { $s_totalpay = ' $'.number_format($totalpay ,2).''; } else { if ($totalpay > $invoice_previous) { $s_totalpay = ' $'.number_format($totalpay ,2).''; } else { if ($totalpay < $invoice_previous) { $s_totalpay = ' $'.number_format($totalpay ,2).''; } else { $s_totalpay = ' $'.number_format($totalpay ,2).''; } } } if ($data['cap']>0) { $cap=' $'.number_format($data['cap'] ,2).''; } else { $cap=''; } // $resultado =''; $i=$i+1; flush(); ob_flush(); echo $resultado; } } ?>

Cont	Type	Invoice Pdf	View	Set up - Trial	Id	Restaurant	Email	Pay	Previous order	QTY ORDER	Previous invoice	CAP	TOTAL INVOICE
'.$data['invoice'].'
'.$i.'	'.$eemail.'	'.$data['invoice'].'		'.$end_trial.'	ID '.$data['idresto'].'	'.$data['restoname'].'	'. $semail.'	'. $data['tipo_pago'].'	'.$qty_previous.'	'. $s_qty_orders.'	$'.number_format($invoice_previous ,2).'	'.$cap.'	'.$s_totalpay.'