PHP Application_Model_GlobalClass::getStatusType方法代码示例

 public function indexAction()
 {
     $formFilter = new Application_Form_Frmsearch();
     $this->view->formFilter = $formFilter;
     Application_Model_Decorator::removeAllDecorator($formFilter);
     $list = new Application_Form_Frmlist();
     $db = new Application_Model_DbTable_DbGlobal();
     // 		$vendor_sql = "SELECT p.order_id, p.order, p.date_order, p.status, v.v_name, p.all_total,u.username
     // 						FROM tb_purchase_order AS p ,
     // 						tb_vendor AS v,rsv_acl_user u
     // 		                WHERE v.vendor_id=p.vendor_id AND u.user_id = p.user_mod ";
     $vendor_sql = "SELECT \n\t\t\t\t  p.order_id,\n\t\t\t\t  p.order,\n\t\t\t\t  p.date_order,\n\t\t\t\t  p.status,\n\t\t\t\t  (SELECT v.v_name FROM tb_vendor AS v WHERE v.vendor_id = p.vendor_id) AS VendorName,\n\t\t\t\t  p.all_total,\n\t\t\t\t  (SELECT u.username FROM rsv_acl_user AS u WHERE u.user_id = p.user_mod) AS userName\n\t\t\t\t  FROM tb_purchase_order AS p WHERE 1";
     $user = $this->GetuserInfoAction();
     $str_condition = " AND p.LocationId";
     $vendor_sql .= $db->getAccessPermission($user["level"], $str_condition, $user["location_id"]);
     $this->view->level = $user["level"];
     if ($this->getRequest()->isPost()) {
         $post = $this->getRequest()->getPost();
         //echo $post["order"];
         if ($post['order'] != '') {
             $vendor_sql .= " AND p.order LIKE '%" . $post['order'] . "%'";
         }
         if ($post['vendor_name'] != '' and $post['vendor_name'] != 0) {
             $vendor_sql .= " AND p.vendor_id =" . $post['vendor_name'];
         }
         // 				if($post['phone'] !=''){
         // 					$vendor_sql .= " AND v.phone LIKE '%".$post['phone']."%'";
         // 				}
         if ($post['status'] != '') {
             $vendor_sql .= " AND p.status =" . $post['status'];
         }
         $start_date = $post['search_start_date'];
         $end_date = $post['search_end_date'];
         if ($start_date != "" && $end_date != "" && strtotime($end_date) >= strtotime($start_date)) {
             $vendor_sql .= " AND p.date_order BETWEEN '{$start_date}' AND '{$end_date}'";
         }
     } else {
         $vendor_sql .= " AND p.status=4 ";
     }
     //echo $vendor_sql;exit();
     $vendor_sql .= " ORDER BY p.order_id DESC";
     //**************************************
     $rows = $db->getGlobalDb($vendor_sql);
     //print_r($rows);exit();
     $glClass = new Application_Model_GlobalClass();
     $rows = $glClass->getStatusType($rows, BASE_URL, true);
     $columns = array("PURCHASE_ORDER_CAP", "ORDER_DATE_CAP", "STATUS_CAP", "VENDOR_NAME_CAP", "TOTAL_CAP_DOLLAR", strtoupper("BY_USER_CAP"));
     $link = array('module' => 'purchase', 'controller' => 'index', 'action' => 'detail-purchase-order');
     // url link to update purchase order
     $urlEdit = BASE_URL . "/purchase/index/update-purchase-order";
     $this->view->list = $list->getCheckList(1, $columns, $rows, array('order' => $link), $urlEdit);
 }

 public function indexAction()
 {
     $formFilter = new Application_Form_Frmsearch();
     $this->view->formFilter = $formFilter;
     $list = new Application_Form_Frmlist();
     $db = new Application_Model_DbTable_DbGlobal();
     $sale_order_sql = "SELECT o.order_id,o.order,o.date_order, o.status,c.cust_name, o.all_total, u.username\n\t\t\t\t\t  FROM tb_sales_order AS o ,tb_customer AS c, rsv_acl_user AS u\n\t\t\t\t\t  WHERE c.customer_id=o.customer_id AND o.user_mod = u.user_id ";
     // 		$sale_order_sql = "SELECT o.order_id,o.order,o.date_order, o.status,c.cust_name, o.all_total, o.paid,o.balance
     // 		FROM tb_sales_order AS o INNER JOIN tb_customer AS c ON c.customer_id=o.customer_id";
     $user = $this->GetuserInfoAction();
     $str_condition = " AND o.LocationId";
     $sale_order_sql .= $db->getAccessPermission($user["level"], $str_condition, $user["location_id"]);
     if ($this->getRequest()->isPost()) {
         $post = $this->getRequest()->getPost();
         //echo $post["order"];
         if ($post['order'] != '') {
             $sale_order_sql .= " AND o.order LIKE '%" . $post['order'] . "%'";
         }
         // 			if($post['customer_id'] !=''){
         // 				$sale_order_sql .= " AND c.customer_id LIKE '%".$post['customer_id']."%'";
         // 			}
         if ($post['sale_agent_id'] != '' and $post['sale_agent_id'] != 0) {
             $sale_order_sql .= " AND o.sales_ref = " . $post['sale_agent_id'];
         }
         if ($post['status'] != '') {
             $sale_order_sql .= " AND o.status =" . $post['status'];
         }
         $start_date = $post['search_start_date'];
         $end_date = $post['search_end_date'];
         if ($start_date != "" && $end_date != "" && strtotime($end_date) >= strtotime($start_date)) {
             $sale_order_sql .= " AND o.date_order BETWEEN '{$start_date}' AND '{$end_date}'";
         }
     } else {
         //$sale_order_sql.="";
     }
     $sale_order_sql .= " ORDER BY o.order_id DESC";
     $rows = $db->getGlobalDb($sale_order_sql);
     $glClass = new Application_Model_GlobalClass();
     $rows = $glClass->getStatusType($rows, BASE_URL, true);
     $columns = array("ORDER_ADD_CAP", "ORDER_DATE_CAP", "STATUS_CAP", "CON_NAME_CAP", "TOTAL_CAP_DOLLAR", "BY_USER_CAP");
     //$columns=array("ORDER_ADD_CAP","ORDER_DATE_CAP","STATUS_CAP", "CON_NAME_CAP","TOTAL_CAP_DOLLAR","PAID_DOLLAR_CAP","BALANCE_CAP");
     $link = array('module' => 'sales', 'controller' => 'sales-order', 'action' => 'detail-sales-order');
     $urlEdit = BASE_URL . "/sales/sales-order/update-sales";
     $this->view->list = $list->getCheckList(1, $columns, $rows, array('order' => $link, 'cust_name' => $link, 'contact_name' => $link), $urlEdit);
     Application_Model_Decorator::removeAllDecorator($formFilter);
 }

 public function indexAction()
 {
     $formFilter = new Application_Form_Frmsearch();
     $this->view->formFilter = $formFilter;
     Application_Model_Decorator::removeAllDecorator($formFilter);
     $list = new Application_Form_Frmlist();
     $db = new Application_Model_DbTable_DbGlobal();
     $vendor_sql = "SELECT p.order_id, p.order, p.date_order, p.status, v.v_name, p.all_total,p.paid,p.balance\n\t\t\t\t\t\tFROM tb_purchase_order AS p INNER JOIN tb_vendor AS v ON v.vendor_id=p.vendor_id ";
     if ($this->getRequest()->isPost()) {
         $post = $this->getRequest()->getPost();
         //echo $post["order"];
         if ($post['order'] != '') {
             $vendor_sql .= " AND p.order LIKE '%" . $post['order'] . "%'";
         }
         if ($post['vendor_name'] != '') {
             $vendor_sql .= " AND v.vendor_id =" . $post['vendor_name'];
         }
         if ($post['phone'] != '') {
             $vendor_sql .= " AND v.phone LIKE '%" . $post['phone'] . "%'";
         }
         if ($post['status'] != '') {
             $vendor_sql .= " AND p.status =" . $post['status'];
         }
         $start_date = $post['search_start_date'];
         $end_date = $post['search_end_date'];
         if ($start_date != "" && $end_date != "" && strtotime($end_date) >= strtotime($start_date)) {
             $vendor_sql .= " AND p.date_order BETWEEN '{$start_date}' AND '{$end_date}'";
         }
     }
     $vendor_sql .= " ORDER BY p.timestamp DESC";
     $rows = $db->getGlobalDb($vendor_sql);
     $glClass = new Application_Model_GlobalClass();
     $rows = $glClass->getStatusType($rows, BASE_URL, true);
     $columns = array("PURCHASE_ORDER_CAP", "ORDER_DATE_CAP", "STATUS_CAP", "VENDOR_NAME_CAP", "TOTAL_CAP_DOLLAR", "PAID_DOLLAR_CAP", "BALANCE_CAP");
     $link = array('module' => 'purchase', 'controller' => 'index', 'action' => 'detail-purchase-order');
     $urlEdit = BASE_URL . "/purchase/index/update-purchase-order";
     $this->view->list = $list->getCheckList(1, $columns, $rows, array('order' => $link), $urlEdit);
 }

 public function productDetailAction()
 {
     if ($this->getRequest()->getParam('id')) {
         $id = $this->getRequest()->getParam('id') ? $this->getRequest()->getParam('id') : '0';
         //if user type wrong url
         $user = $this->GetuserInfoAction();
         $gb = new Application_Model_DbTable_DbGlobal();
         if ($user["level"] != 1 and $user["level"] != 2) {
             $exist = $gb->productLocation($id, $user["location_id"]);
             if ($exist == "") {
                 $this->_redirect("product/index/index");
             }
         } else {
             $pro_exist = $gb->myProductExist($id);
             if (!$pro_exist) {
                 $this->_redirect("product/index/index");
             }
         }
         $session_stock = new Zend_Session_Namespace('stock');
         $productinfo = new Product_Model_DbTable_DbProduct();
         //get product info detail
         $getpro_info_rows = $productinfo->getProductInfoDetail($id);
         if ($getpro_info_rows['photo'] == "") {
             $getpro_info_rows['photo'] = "no-img.gif";
         }
         $this->view->photo = $getpro_info_rows['photo'];
         $this->view->form = $getpro_info_rows;
         //for view product loaction 22/8/13
         $orderDetail = $productinfo->getOrderItemVeiw($id);
         $this->view->lostItemDetail = $orderDetail;
         //for product in stock 22/8/13
         if ($user["level"] == 1 or $user["level"] == 2) {
             $rowproduct = $productinfo->getProductStock($id);
             $this->view->pro_qty = $rowproduct;
         }
         //get product move history 23/8/13
         $rows = $productinfo->moveproduct($id);
         $list = new Application_Form_Frmlist();
         $glClass = new Application_Model_GlobalClass();
         $rows = $glClass->getTransactionType($rows, BASE_URL, true);
         $columns = array("TRANSACTION_TYPE_CAP", "DATE_CAP", "LOCATION_NAME_CAP", "QTY_CAP", "QTY_BEFORE_CAP", "QTY_AFTER_CAP", "REMARK_CAP", "BY_USER_CAP");
         $link = array('module' => 'product', 'controller' => 'index', 'action' => 'update');
         $this->view->list_history = $list->getCheckList(1, $columns, $rows);
         //view sale order history
         $row_sale_history = $productinfo->getSaleHistory($id);
         $glClass = new Application_Model_GlobalClass();
         $row_sale_history = $glClass->getTypeHistory($row_sale_history, BASE_URL, true);
         $row_sale_history = $glClass->getStatusType($row_sale_history, BASE_URL, true);
         $columns1 = array("TYPE_CAP", "ORDER_ADD_CAP", "CUSTOMER_CAP", "ORDER_DATE_CAP", "ORDER_STATUS_CAP", "TOTAL_PRICE_CAP", "QTY_CAP", "UNIT_PRICE_CAP", "SUB_TOTAL_CAP");
         $link1 = array('module' => 'product', 'controller' => 'index', 'action' => 'update');
         $list = new Application_Form_Frmlist();
         $this->view->list_order_history = $list->getCheckList(1, $columns1, $row_sale_history, array('item_name' => $link1, 'Name' => $link1), "", "items", "left", false, "move_history");
         //for purchase history
         $row_purchase_history = $productinfo->getPurchaseHistory($id);
         $glClass = new Application_Model_GlobalClass();
         $row_purchase_history = $glClass->getTypeHistory($row_purchase_history, BASE_URL, true);
         $row_purchase_history = $glClass->getStatusType($row_purchase_history, BASE_URL, true);
         $columns1 = array("TYPE_CAP", "ORDER_ADD_CAP", "VENDOR_CAP", "ORDER_DATE_CAP", "ORDER_STATUS_CAP", "TOTAL_PRICE_CAP", "QTY_CAP", "UNIT_PRICE_CAP", "SUB_TOTAL_CAP");
         $link_pur = array('module' => 'product', 'controller' => 'index', 'action' => 'update');
         $list = new Application_Form_Frmlist();
         $this->view->list_purchase_history = $list->getCheckList(1, $columns1, $row_purchase_history, array('item_name' => $link_pur, 'Name' => $link_pur), "", "items", "left", false, "purchase_history");
     }
 }