public function loadTours()
{
$model=CashboxChangeRequests::model()->with('user')->findAll('(approvedBy IS NULL) AND (reject=0)');
if($model===null)
throw new CHttpException(404,'The cashbox model does not exist.');
return $model;
}
public function createpdf($sched)
{
$id_control = Yii::app()->user->id;
$guide = User::model()->with('contact_ob')->findByPk($id_control);
$date_format = strtotime($sched->date);
$date_bd = date('Y-m-d',$date_format);
$dt =$date_bd.' '.$sched->starttime;
$tour = SegTourroutes::model()->findByPk($sched->tourroute_id);
$mails=array();
$fn='.'; $ln='.';
if((!is_null($guide->contact_ob['firstname'])) && $guide->contact_ob['firstname']!=''){$fn = $guide->contact_ob['firstname']{0};}else{$fn='0';}
if((!is_null($guide->contact_ob['surname'])) && $guide->contact_ob['surname']!=''){$ln = $guide->contact_ob['surname']{0};}else{$ln='0';}
$c = $tour->city['seg_cityname']{0};
$year = date('y',time());
$b = $tour->city['seg_cityname']{0};
$num=0;
$criteria_i = new CDbCriteria;
$criteria_i->condition = 'guide1_id=:guide1_id AND openTour=:openTour';
$criteria_i->params = array(':guide1_id'=>$id_control,'openTour'=>1);
$schedall = SegScheduledTours::model()->findAll($criteria_i);
foreach($schedall as $item){
$year_item = date('y',$item->date_now);
if($year_item == $year){
$num++;
}
}
$num = $num+1;
// $sched->GN_string = $fn.$ln.$c.'/'.$id_control.'/'.$year.'/'.$num;
$sched->GN_string = $fn.$ln.$c.'/'.$year.'/'.$num;
$sched->openTour = 1;//create pdf
//tourroutes
$criteria_tourroutes = new CDbCriteria;
$criteria_tourroutes->condition = 'usersid=:usersid AND tourroutes_id=:tourroutes_id';
$criteria_tourroutes->params = array(':usersid'=>$sched->user_ob->id,'tourroutes_id'=>$tour->id_tour_categories);
$tourroutes = SegGuidesTourroutes::model()->find($criteria_tourroutes);
$vat= Yii::app()->db->createCommand("SELECT value from mainoptions where name='Vat'")->queryScalar();
$firma= Yii::app()->db->createCommand("SELECT value from mainoptions where name='Firma'")->queryScalar();
$sum_itog=0;
$sum_bar=0;
$count_cust=0;
$max= Yii::app()->db->createCommand("SELECT max(InvoiceNumber) from seg_guidestourinvoices where cityid=".$tour->cityid)->queryScalar();
$max_i = $max+1;
foreach ($sched->guidestourinvoices as $invoice)
{
$model=$invoice->guidestourinvoicescustomers;
$overAllIncome=0;
$cashIncome=0;
$count_inv=0;
$invoice_id = $invoice->idseg_guidesTourInvoices;
for($k=0;$k<count($model);$k++){
$kk=$model[$k]->idseg_guidesTourInvoicesCustomers;
if($model[$k]->isPaid == 1) $count_cust++;
$count_inv++;
}
$invoice->status = 1;
$sum_itog += $invoice->overAllIncome;
$sum_bar += $invoice->cashIncome;
$invoice->TA_string = 'TA'.$b.$year.'/'.$max_i;
$invoice->InvoiceNumber =$max_i;
$invoice->save();
$tmpname=$this->doPDF($sched, $invoice);
$mails[]=array($invoice->contact['email'],$tmpname);
}
$sum_vat = round($sum_itog*(1-1/($vat/100+1)),2);
$sum_b_vat = $sum_itog - $sum_vat;
$cifra = $count_cust - $tourroutes->guest_variable;
if($cifra<=0){$cifra=0;}//turists >
$gonorar = $tourroutes->base_provision+$cifra*$tourroutes->guestsMinforVariable;//summa gonorar
$gonorar_vat = $gonorar*(1-1/($vat/100+1));
$gonorar_vat = number_format($gonorar_vat, 2, '.', ' ');
$cashnew=new CashboxChangeRequests;
$cashnew->id_users=$id_control;
$cashnew->approvedBy=$id_control;
$cashnew->delta_cash = $sum_bar;
$datetime = date('Y-m-d H:i:s', time());
$cashnew->approval_date=$datetime;
$cashnew->id_type = 1;
$cashnew->sched_user_id = $sched->idseg_scheduled_tours;
$cashnew->save();
$cashnew1 = new CashboxChangeRequests;
$cashnew1->id_users=$id_control;
$cashnew1->approvedBy=$id_control;
$cashnew1->approval_date=$datetime;
$cashnew1->sched_user_id = $sched->idseg_scheduled_tours;
$cashnew1->delta_cash = -$gonorar;
$cashnew1->id_type = 2;
$cashnew1->save();
$cashnow=$this->cashsum;
//************************************PDF CREATE***************************************************//
//$pdf->SetFont('freeserif', '', 14);
$printOrders = null;
$forpdf=array();
$forpdf['gonorar_vat']=$gonorar_vat;
$forpdf['firma']=$firma;
$forpdf['cifra']=$cifra;
$forpdf['base_provision'] = number_format($tourroutes->base_provision, 2, '.', ' ');
$forpdf['guestsMinforVariable'] = number_format($tourroutes->guestsMinforVariable, 2, '.', ' ');
$forpdf['gonorar_zero'] = number_format($gonorar, 2, '.', ' ');
$forpdf['cashBefore'] = number_format($cashnow, 2, '.', ' ');
$forpdf['sum_bar_zero'] = number_format($sum_bar, 2, '.', ' ');
$forpdf['cashnow_zero'] = number_format($cashnow-$gonorar+$sum_bar, 2, '.', ' ');
$forpdf['delta_cash_zero'] = number_format($sum_bar-$gonorar, 2, '.', ' ');
$forpdf['cashnow_enter'] = number_format($cashnow+$gonorar-$sum_bar, 2, '.', ' ');
$name_pdf2=$this->doPDF($sched, $forpdf);
// var_dump($mails);return false;
$sched->additional_info2=$name_pdf2;
$sched->save();
$message="Dear sirs, \n The invoice from Cherry tours.";
$subject = "The invoice from Cherry tours";
foreach ($mails as $value) {
$this->sendMail($value[0],$subject,$message, __DIR__.'/../../../../filespdf/'.$value[1].'.pdf');
unlink(__DIR__.'/../../../../filespdf/'.$value[1].'.pdf');
}
$this->redirect( Yii::app()->createUrl('/filespdf/'.$name_pdf2.'.pdf') );
}