Ejemplo n.º 1
0
	public function setCvalue($key,$value)
	{
		$this->name=$key;
		$model=$this->find("name='".$key."'");
		if($model===null)
		{
			$model= new Mainoptions;
			$model->setAttribute('name',$key);
			$model->setAttribute('value',$value);
			$model->save();
		}
		else 
		{
			$model->setAttribute('value',$value);
			$model->save();
		}

	}
Ejemplo n.º 2
0
 public function Footer()
 {
     // Position at 15 mm from bottom
     $this->SetY(-2.5);
     // Set font
     $this->SetFont('helvetica', 'I', 9);
     // Page number
     /*                 $str ='<table style="color:#66A3BC; width:100%;"><tbody><tr>'
                             . '<td><div>Cherrytours GmbH<br>Mittelstr. 30<br>10117 Berlin</div></td>'
                             . '<td><div>Geschäftsleitung:<br>Marina Kuranova,<br>Christian Zeitsch</div></td>'
                             . '<td><div>HRB Nr: 183404<br>USt-IDNr: DE304401873<br>SteuerNr: 1130/251/50018</div></td>'
                             . '<td><div>Commerzbank<br>IBAN DE59 8204 0000 0815 1367 00<br>BIC COBADEFFXXX</div></td>'
                             . '</tr></tbody></table>';
      */
     $str = '<table style="color:#983157; width:100%;"><tbody><tr>' . '<td><div>' . Mainoptions::model()->getCvalue('Firma') . '<br>' . Mainoptions::model()->getCvalue('address street') . '<br>' . Mainoptions::model()->getCvalue('address city') . '</div></td>' . '<td><div>' . Mainoptions::model()->getCvalue('Geschäftsleitung') . '<br>' . Mainoptions::model()->getCvalue('NameMarina') . ',<br>' . Mainoptions::model()->getCvalue('NameChristian') . '</div></td>' . '<td><div>' . Mainoptions::model()->getCvalue('Tax4') . '<br>' . Mainoptions::model()->getCvalue('TAX5') . '<br>' . Mainoptions::model()->getCvalue('Tax6') . '</div></td>' . '<td><div>' . Mainoptions::model()->getCvalue('Bank1') . '<br>' . Mainoptions::model()->getCvalue('Bank3') . '<br>' . Mainoptions::model()->getCvalue('Bank2') . '</div></td>' . '</tr></tbody></table>';
     $this->writeHTMLCell(0, 0, '', '', $str, 0, 1, 0, true, '', true);
 }
Ejemplo n.º 3
0
	public function loadMO($id)
	{
		$model=Mainoptions::model()->findByPk($id);
		if($model===null)
			throw new CHttpException(404,'The requested page does not exist.');
		return $model;
	}
Ejemplo n.º 4
0
        public function actionAjaxInfo()
	{
	if (!Yii::app()->request->isAjaxRequest)
			{
				echo CJSON::encode(array(
					'status'=>'failure', 
					'div'=>'No Request'));
//					'div'=>$this->renderPartial('_form', array('model'=>$model), true)));
				exit;               
			}
		$id_sched = $_POST['id_sched'];
		$date = $_POST['date'];
		$time = $_POST['time'];
		$sched = SegScheduledTours::model()->findByPk($id_sched);

		$id_control = $sched->guide1_id;
		$guide = User::model()->with('guide_ob')->findByPk($id_control);
       $role_control = $guide->id_usergroups;    

   
		//sched
		
		//tour
		$tour = SegTourroutes::model()->findByPk($sched->tourroute_id);
		
		//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);
		$gonorar_tour = SegGuidesTourroutes::model()->find($criteria_tourroutes);
		
		//mainoption
		$criteria_vat = new CDbCriteria;
		$criteria_vat->condition = 'name=:name ';
		$criteria_vat->params = array(':name'=>'Vat');
		$vat = Mainoptions::model()->find($criteria_vat)->value;
				
		$command=Yii::app()->db->createCommand();
                $command->select('SUM(cashIncome) AS sumk');
                $command->from('seg_guidestourinvoices');
                $command->where('id_sched=:id_sched', array(':id_sched'=>$sched->idseg_scheduled_tours));
                $cashincome= $command->queryScalar();
        	//segguidestourinvoicescustomers
                $invoicecustomer=SegGuidestourinvoicescustomers::model()->with('tourinvoice')->count("id_sched=".$sched->idseg_scheduled_tours." AND isPaid=1");
                $tot_cust=1;

                $cifra = $invoicecustomer - $gonorar_tour->guest_variable;
		if($cifra<=0){$cifra=0;}//turists >
		$gonorar = $gonorar_tour->base_provision+$cifra*$gonorar_tour->guestsMinforVariable;//summa gonorar
               $gonorar_vat = $gonorar*(1-1/($vat/100+1));
		$gonorar_vat = number_format($gonorar_vat, 2, '.', ' ');
		
		$result=$this->renderPartial('info',array(
			'gonorar_tour'=>$gonorar_tour,
			'cifra'=>$cifra,
			'gonorar'=>$gonorar,
			'gonorar_vat'=>$gonorar_vat,
			'vat'=>$vat,
			'vattype'=>$guide->guide_ob['paysUSt'],
			'cash'=>$this->cashsum,
			'cashincome'=>$cashincome,
			
			'id_sched'=>$id_sched,
			'date'=>$date,
			'time'=>$time,
			'ajax'=>true,
		),true);
				echo CJSON::encode(array(
					'status'=>'failure', 
					'div'=>$result));
	}