public function operationstatechangeajaxAction() { try { $mapper = new Gyuser_Model_OperationsDataMapper(); $obj = new Gyuser_Model_Operations(); $request = $this->getRequest(); if ($this->getRequest()->isPost()) { $this->_helper->layout->disableLayout(); $this->_helper->viewRenderer->setNoRender(); $operationId = $request->operation_id; $stateId = (int) $request->state_id; $obj->setId($operationId); $obj->setState($stateId); $chequesList = null; $chequeId = null; switch ($stateId) { //step2 case 2: $obj->setCave_id($request->cave_id); break; //step3 //step3 case 3: //report approved //report approved case 4: //report denied $obj->setReport($request->report); break; //step 4 //step 4 case 5: $chequesList = $request->cheques_list; $obj->setAmount($request->total_amount); $obj->setPlan_id($request->plan_id); $obj->setInterests_id($request->interests_id); break; case 8: case 9: $chequeId = $request->id; $chequesList = $request->cheques_list; $obj->setAmount($request->total_amount); $obj->setPlan_id($request->plan_id); break; //step 5 //step 5 case 6: //en camino //en camino case 7: //en camino lavalle //en camino lavalle case 99: //cancel op. //cancel op. default: break; } $result = $mapper->OperationStateChange($obj, $chequesList, $chequeId); if ($result) { echo $result; } else { echo "f"; } } } catch (Exception $e) { echo $e; } }
public function GetOperationsByProviderId($provider_id) { $table = $this->getDbTable(); $select = $table->select(); $select->setIntegrityCheck(false); $select->from(array('opr' => 'operations'), array('id', 'client_id', 'date', 'amount', 'observations', 'report', 'date_added', 'state_order_id', 'cave_id')); $select->joinLeft(array('prov' => 'providers'), 'opr.cave_id = prov.id', array('name as cave_name', 'comision_rate')); $select->joinLeft(array('cls' => 'clients'), 'opr.client_id = cls.id', array('first_name', 'last_name')); $select->where('opr.cave_id = ?', $provider_id); $select->where('opr.liquidacion_id IS NULL'); //NOTE! gus also wants to show the operations with state "En Lavalle". $select->where('opr.state_order_id = 8 OR opr.state_order_id = 9 OR opr.state_order_id = 10 OR opr.state_order_id = 11'); $select->order('opr.id ASC'); $resultSet = $table->fetchAll($select); $entries = array(); foreach ($resultSet as $row) { $entry = new Gyuser_Model_Operations(); $entry->setId($row->id); $entry->setClient_id($row->client_id); $entry->setDate(date("d/m/Y", strtotime($row->date))); $entry->setAmount($row->amount); $entry->setState($row->state_order_id); $entry->setObservations($row->observations); $entry->setReport($row->report); $entry->setProv_name($row->cave_name); $entry->setProv_commission_rate($row->comision_rate); $pMapper = new Gyuser_Model_ProvidersDataMapper(); $commissionAmt = $pMapper->calculateComisionAmt($row->amount, $row->comision_rate); $entry->setProv_commission_amt($commissionAmt); $provPayment = $pMapper->calculateProvPayment($row->amount, $commissionAmt); $entry->setProv_payment($provPayment); /* $provider_obj = new Gyuser_Model_Providers(); $provider_obj->setName($row->cave_name); $provider_obj->setComisionRate($row->comision_rate); $pMapper = new Gyuser_Model_ProvidersDataMapper(); $comisionAmt = $pMapper->calculateComisionAmt($row->amount, $row->comision_rate); $provPayment = $pMapper->calculateProvPayment($row->amount, $comisionAmt); $provider_obj->setComisionAmt($comisionAmt); $provider_obj->setProvPayment($provPayment); $entry->setProvider_obj($provider_obj); * */ $clientObj = new Gyuser_Model_User(); $clientObj->setFirst_name($row->first_name); $clientObj->setLast_name($row->last_name); $entry->setUser_obj($clientObj); $entries[] = $entry; } return $entries; }