PHP Application_Model_GlobalClass::getImgStatus Examples

Example #1

File: IndexController.php Project: pingitgroup/stockpingitgroup

 public function indexLocationAction()
 {
     $db = new Application_Model_DbTable_DbGlobal();
     $formFilter = new Product_Form_FrmProductFilter();
     $frmsearch = $formFilter->searchLocation();
     $this->view->formFilter = $frmsearch;
     $list = new Application_Form_Frmlist();
     $sql = "select loc.LocationId, loc.Name, loc.contact, loc.phone,username, loc.status,remark \n\t\tfrom tb_sublocation AS loc\n\t\tINNER JOIN rsv_acl_user as u ON\n\t\tu.user_id=loc.user_id\n\t\tWHERE Name!='' ";
     if ($this->getRequest()->isPost()) {
         $post = $this->getRequest()->getPost();
         if ($post['location_name'] != '') {
             $sql .= " AND Name LIKE '%" . $post['location_name'] . "%'";
         }
         if ($post['contact_name'] != '') {
             $sql .= " AND contact LIKE '%" . $post['contact_name'] . "%'";
         }
         if ($post['address_name'] != '') {
             $sql .= " AND stock_add LIKE '%" . $post['address_name'] . "%'";
         }
         if ($post['phone'] != '') {
             $sql .= " AND phone LIKE '%" . $post['phone'] . "%'";
         }
     }
     $sql .= " ORDER BY loc.LocationId DESC";
     $rows = $db->getGlobalDb($sql);
     $columns = array("LOCATION_NAME", "CON_NAME", "PHONE_NUM", "BY_USER", "STATUS", "REMARK");
     $link = array('module' => 'product', 'controller' => 'index', 'action' => 'detail-stock');
     $urlEdit = BASE_URL . "/product/index/update-stock";
     $glClass = new Application_Model_GlobalClass();
     $rows = $glClass->getImgStatus($rows, BASE_URL, true);
     $this->view->list = $list->getCheckList(1, $columns, $rows, array('name' => $link), $urlEdit);
     Application_Model_Decorator::removeAllDecorator($formFilter);
 }