예제 #1
0
 public function dashboardAction()
 {
     try {
         $sessionNamespace = new Zend_Session_Namespace();
         if ($sessionNamespace->loginAuth == true) {
             $authDetail = $sessionNamespace->authDetail;
             $oprType = $authDetail->getType();
             $this->view->oprType = $oprType;
             $this->view->oprId = $authDetail->getId();
             if ($oprType == 1) {
                 /*
                 $cMapper = new Gyuser_Model_OtherCavesDataMapper();
                 $cObj = new Gyuser_Model_OtherCaves();
                 $cObj->setId(1);
                 $cList = $cMapper->GetCaveById($cObj);
                 $this->view->cList = $cList;
                 $sMapper = new Gyuser_Model_SupplierOperationsDataMapper();
                 $sList = $sMapper->GetAllSuppliers();
                 */
                 $pMapper = new Gyuser_Model_ProvidersDataMapper();
                 $this->view->pList = $pMapper->getProviders();
                 $cMapper = new Gyuser_Model_ChequesDataMapper();
                 $cObj = new Gyuser_Model_Cheques();
                 $cObj->setStatus(1);
                 $this->view->ctAmount = $cMapper->GetTotalAmountByStats($cObj);
                 $cObj->setStatus(4);
                 $this->view->cpAmount = $cMapper->GetTotalAmountByStats($cObj);
                 $sMapper = new Gyuser_Model_OperationsDataMapper();
                 $current_date = date('Y-m-d');
                 /*************************************** Operaciones widget values   *****************************/
                 $this->view->CurrentMonthHalfCave = $sMapper->GetOperationsAmount(findFirstAndLastDay($current_date), true);
                 $this->view->CurrentMonth = $sMapper->GetOperationsAmount(findFirstAndLastDay($current_date), true);
                 $this->view->CurrentQuarter = $sMapper->GetOperationsAmount(findFirstAndLastDatesOfCurrentQuater($current_date), true);
                 $this->view->CurrentSemester = $sMapper->GetOperationsAmount(findFirstAndLastDatesOfCurrentSemester($current_date), true);
                 $this->view->CurrentYear = $sMapper->GetOperationsAmount(findFirstAndLastDatesOfCurrentYear($current_date), true);
                 $this->view->PrevMonthToDate = $sMapper->GetOperationsAmount(prevFirstAndCurrentDay($current_date), true);
                 $this->view->PrevQuaterToDate = $sMapper->GetOperationsAmount(findFirstAndLastCurrentDatesOfPrevQuater($current_date), true);
                 $this->view->PrevSemesterToDate = $sMapper->GetOperationsAmount(findFirstAndLastCurrentDatesOfPrevSemester($current_date), true);
                 $this->view->PrevYearToDate = $sMapper->GetOperationsAmount(findFirstAndLastCurrentDatesOfPrevYear($current_date), true);
                 $PrevMonthTotal = $sMapper->GetOperationsAmount(findPrevMonthFirstAndLastDay($current_date), true, true);
                 $PrevQuaterTotal = $sMapper->GetOperationsAmount(findFirstAndLastDatesOfPrevQuater($current_date), true, true);
                 $PrevSemesterTotal = $sMapper->GetOperationsAmount(findFirstAndLastDatesOfPrevSemester($current_date), true, true);
                 $PrevYearTotal = $sMapper->GetOperationsAmount(findFirstAndLastDatesOfPrevYear($current_date), true, true);
                 $this->view->PrevMonthTotal = $PrevMonthTotal;
                 $this->view->PrevQuaterTotal = $PrevQuaterTotal;
                 $this->view->PrevSemesterTotal = $PrevSemesterTotal;
                 $this->view->PrevYearTotal = $PrevYearTotal;
                 $this->view->PrevMonthToDateAvg = $sMapper->GetOperationsAmountAvg(findPrevMonthFirstAndLastDay($current_date), findFirstAndLastDay($current_date), $PrevMonthTotal);
                 $this->view->PrevQuaterToDateAvg = $sMapper->GetOperationsAmountAvg(findFirstAndLastDatesOfPrevQuater($current_date), findFirstAndLastDatesOfCurrentQuater($current_date), $PrevQuaterTotal);
                 $this->view->PrevSemesterToDateAvg = $sMapper->GetOperationsAmountAvg(findFirstAndLastDatesOfPrevSemester($current_date), findFirstAndLastDatesOfCurrentSemester($current_date), $PrevSemesterTotal);
                 $this->view->PrevYearToDateAvg = $sMapper->GetOperationsAmountAvg(findFirstAndLastDatesOfPrevYear($current_date), findFirstAndLastDatesOfCurrentYear($current_date), $PrevYearTotal);
                 $OperationsAmountByPrevMonths = $sMapper->GetOperationsAmountByPrevMonths($current_date, 4);
                 $this->view->OperationsAmountByPrevMonths = json_encode($OperationsAmountByPrevMonths, JSON_FORCE_OBJECT);
                 /************************************ EOF Operaciones widget values   ***********************************/
                 $AmounByPayedCheques = $cMapper->GetAmounByPayedCheques();
                 $AmounByPayedCheques0To30Days = $cMapper->GetAmounByPayedCheques0To30Days();
                 $AmounByPayedCheques30To60Days = $cMapper->GetAmounByPayedCheques30To60Days();
                 $AmounByPayedCheques60To90Days = $cMapper->GetAmounByPayedCheques60To90Days();
                 $AmounByPayedCheques120Days = $cMapper->GetAmounByPayedCheques120Days();
                 $this->view->AmounByPayedCheques = $AmounByPayedCheques;
                 $this->view->AmounByPayedCheques0To30Days = $AmounByPayedCheques0To30Days;
                 $this->view->AmounByPayedCheques30To60Days = $AmounByPayedCheques30To60Days;
                 $this->view->AmounByPayedCheques60To90Days = $AmounByPayedCheques60To90Days;
                 $this->view->AmounByPayedCheques120Days = $AmounByPayedCheques120Days;
                 $AmounByChequesStatusAcredited = $cMapper->GetAmounByChequesStatusAcredited($current_date);
                 $ChequeAmountByPrevMonths = $cMapper->GetChequeAmountByPrevMonths($current_date, 4);
                 $this->view->AmounByChequesStatusAcredited = $AmounByChequesStatusAcredited;
                 $this->view->ChequeAmountByPrevMonths = $ChequeAmountByPrevMonths;
                 $RejectedChequesBalanceByCal = $cMapper->GetRejectedChequesBalanceByCal();
                 $PrecOfRejectedChequesByPassed = $cMapper->GetPrecOfRejectedChequesByPassed();
                 $RejectedChequesBalanceByCaves = $cMapper->getRejectedChequesBalance();
                 //GetRejectedChequesBalanceByCaves();
                 $RejectedChequesBalanceByCavesAndMonths = $cMapper->GetRejectedChequesBalanceByCavesAndMonths($current_date, 4);
                 /*
                 $AmounByPayedCheques0To30DaysByCaves = $cMapper->GetAmounByPayedCheques0To30DaysByCaves();
                 $AmounByPayedCheques30To60DaysByCaves = $cMapper->GetAmounByPayedCheques30To60DaysByCaves();
                 $AmounByPayedCheques60To90DaysByCaves = $cMapper->GetAmounByPayedCheques60To90DaysByCaves();
                 $AmounByPayedChequesAfter90DaysByCaves = $cMapper->GetAmounByPayedChequesAfter90DaysByCaves();
                 $this->view->AmounByPayedCheques0To30DaysByCaves = $AmounByPayedCheques0To30DaysByCaves;
                 $this->view->AmounByPayedCheques30To60DaysByCaves = $AmounByPayedCheques30To60DaysByCaves;
                 $this->view->AmounByPayedCheques60To90DaysByCaves = $AmounByPayedCheques60To90DaysByCaves;
                 $this->view->AmounByPayedChequesAfter90DaysByCaves = $AmounByPayedChequesAfter90DaysByCaves;
                 */
                 $this->view->amountsPassedByDates = $cMapper->getEachAmountPassedByDates();
                 $this->view->RejectedChequesBalanceByCal = $RejectedChequesBalanceByCal;
                 $this->view->PrecOfRejectedChequesByPassed = $PrecOfRejectedChequesByPassed;
                 $this->view->RejectedChequesBalanceByCaves = $RejectedChequesBalanceByCaves;
                 $this->view->RejectedChequesBalanceByCavesAndMonths = $RejectedChequesBalanceByCavesAndMonths;
             }
             /* notification tasks starts */
             $tasksModel = new Gyuser_Model_CRMTasks();
             $this->view->myTasks = $tasksModel->getMyTasks();
             //$this->view->pending = $tasksModel->getMyPendingTasks();
             if ($oprType == 1) {
                 $this->view->adminPending = $tasksModel->getMyPendingTasks(true);
                 $this->view->adminMonitor = $tasksModel->getAdminMonitor();
                 $this->view->completedTasks = FALSE;
             } else {
                 $this->view->adminPending = FALSE;
                 $this->view->adminMonitor = FALSE;
                 $this->view->completedTasks = $tasksModel->getCompletedTasks();
             }
             $this->view->oprType = $oprType;
             /* notification tasks ends */
         } else {
             $this->_helper->redirector('login', 'index', 'gyuser');
         }
     } catch (Exception $e) {
         echo $e;
     }
 }