예제 #1
0
 protected function getConfigDisplay()
 {
     $select = $this->sqlObj->select();
     $select->from('config')->where('id = 1');
     $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
     $result = $result[0];
     return \Zend\Json\Json::decode($result['display']);
 }
예제 #2
0
 public function countItem($arrParam = null, $options = null)
 {
     if ($options == null) {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select()->from(array('b' => 'users'))->columns(array('count' => new Expression('COUNT(b.id)')));
         $select->where('parent = ' . $arrParam['parent']);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = $result[0]['count'];
         return $result;
     }
 }
예제 #3
0
 public function getItem($arrParam = null, $options = null)
 {
     if ($options['task'] == 'get-item') {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select()->from('comment');
         $select->where('comment.id =' . $arrParam['id']);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = $result[0];
         return $result;
     }
 }
 public function getItem($arrParam = null, $options = null)
 {
     if ($options['task'] == 'get-item') {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select()->from('contact_real_estate');
         $select->join(array('r' => 'real_estate'), 'r.id = contact_real_estate.real_estate_id', array('rid' => 'id', 'rcat_id' => 'cat_id', 'title', 'images'), $select::JOIN_LEFT);
         $select->join(array('retype' => 'category'), 'retype.id = r.cat_id', array('name_type' => 'name'), $select::JOIN_LEFT);
         $select->where('contact_real_estate.id =' . $arrParam['id']);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = $result[0];
         return $result;
     }
 }
 public function countItem($arrParam = null, $options = null)
 {
     if ($options == null) {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select()->from(array('c' => 'contract_forms'))->columns(array('count' => new Expression('COUNT(id)')));
         if (!empty($arrParam['cat_id'])) {
             $select->where('c.cat_id = ' . $arrParam['cat_id']);
         }
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = $result[0]['count'];
         return $result;
     }
 }
예제 #6
0
 public function itemInselectBox($arrParam = null, $options = null)
 {
     if ($options['task'] == 'list-item-category-news') {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select()->from('category')->columns(array('id', 'name', 'parents' => 'parent'))->where('type = "category_legislationhousing"');
         $resultRoot[] = array('id' => 1, 'name' => 'Root', 'parents' => 0);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = array_merge($resultRoot, $result);
         $system = new \ZendVN\System\Recursive($result);
         $result = $system->buildArray(0);
         $default[] = array('id' => '', 'name' => 'Danh mục', 'level' => 1);
         $result = array_merge($default, $result);
         return $result;
     }
 }
 public function getItem($arrParam = null, $options = null)
 {
     if ($options['task'] == 'get-item') {
         $row = $this->tableGateway->select(array('id' => $arrParam['id']))->current();
         if (empty($row)) {
             return false;
         }
     }
     if ($options['task'] == 'get-item-email-template') {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select()->from(array('e' => 'email_marketing_template'))->where('e.id = ' . $arrParam);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = $result[0];
         return $result;
     }
     return $row;
 }
예제 #8
0
 public function getItem($arrParam = null, $options = null)
 {
     if ($options['task'] == 'get-item') {
         $row = $this->tableGateway->select(array('id' => $arrParam['id']))->current();
         if (empty($row)) {
             return false;
         }
     }
     if ($options['task'] == 'file') {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select();
         $select->from(array('mfile' => 'manager_file'))->join(array('mfolder' => 'manager_folder'), 'mfolder.id = mfile.folder_id', array('name_folder' => 'name'), $select::JOIN_LEFT)->where('mfile.id =' . $arrParam['id']);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = !empty($result) ? $result[0] : '';
         return $result;
     }
     return $row;
 }
예제 #9
0
 public function getItem($arrParam = null, $options = null)
 {
     if ($options['task'] == 'get-item') {
         $row = $this->tableGateway->select(array('id' => $arrParam['id']))->current();
         if (empty($row)) {
             return false;
         }
     }
     if ($options['task'] == 'get-item-thoi-han-su-dung') {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select()->from('service_account_register')->columns(array('service_account_id', 'date_end'));
         $select->join(array('se' => 'service_account'), 'se.id = service_account_register.service_account_id', array('name_service' => 'name'), $select::JOIN_LEFT);
         $select->where('user_id = ' . $arrParam);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = $result[0];
         return $result;
     }
     return $row;
 }
예제 #10
0
 public function getItem($arrParam = null, $options = null)
 {
     if ($options['task'] == 'get-item') {
         $row = $this->tableGateway->select(array('id' => $arrParam['id']))->current();
         if (empty($row)) {
             return false;
         }
     }
     if ($options == null) {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select()->from(array('f' => 'fengshui_news'))->columns(array('id', 'cat_id', 'title', 'description', 'content', 'images', 'status', 'date_time', 'order', 'images'));
         $select->join(array('cat' => 'category'), 'cat.id = f.cat_id', array('name_category' => 'name'), $select::JOIN_LEFT);
         $select->where('f.id =' . $arrParam['id']);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = $result[0];
         return $result;
     }
     return $row;
 }
 public function getItem($arrParam = null, $options = null)
 {
     if ($options['task'] == 'get-item') {
         $row = $this->tableGateway->select(array('id' => $arrParam['id']))->current();
         if (empty($row)) {
             return false;
         }
     }
     if ($options == null) {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select()->from('contact_agency');
         $select->join(array('u' => 'users'), 'u.id = contact_agency.user_id', array('fullname_contact' => 'fullname'), $select::JOIN_LEFT);
         $select->where('contact_agency.id =' . $arrParam['id']);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = $result[0];
         return $result;
     }
     return $row;
 }
 public function getItem($arrParam = null, $options = null)
 {
     if ($options['task'] == 'get-item') {
         $row = $this->tableGateway->select(array('id' => $arrParam['id']))->current();
         if (empty($row)) {
             return false;
         }
     }
     if ($options == null) {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select()->from(array('l' => 'legislation_housing'));
         $select->join(array('cat' => 'category'), 'cat.id = l.cat_id', array('name_category' => 'name'), $select::JOIN_LEFT);
         $select->where('l.id =' . $arrParam['id']);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = $result[0];
         return $result;
     }
     return $row;
 }
 public function getItem($arrParam = null, $options = null)
 {
     if ($options['task'] == 'get-item') {
         $row = $this->tableGateway->select(array('id' => $arrParam['id']))->current();
         if (empty($row)) {
             return false;
         }
     }
     if ($options == null) {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select();
         $select = $sqlObj->select()->from(array('s' => 'service_account_register'));
         $select->join(array('u' => 'users'), 's.user_id = u.id', array('fullname', 'phone', 'website', 'email'), $select::JOIN_LEFT);
         $select->join(array('sa' => 'service_account'), 's.service_account_id = sa.id', array('name', 'normal', 'vip', 'hot', 'free', 'chinhchu', 'price'), $select::JOIN_LEFT);
         $select->where('s.id =' . $arrParam['id']);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = $result[0];
         return $result;
     }
     return $row;
 }
예제 #14
0
 public function getItem($arrParam = null, $options = null)
 {
     if ($options['task'] == 'get-item-notification-template') {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select();
         $select->from(array('n' => 'notificationtemplate'))->columns(array('id', 'content'));
         $select->where('n.id = ' . $arrParam['id']);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = $result[0];
         return $result;
     }
     if ($options == null) {
         return $result = $this->tableGateway->select(function (Select $select) use($arrParam) {
             $select->columns(array('id', 'username', 'fullname', 'email', 'group_id'));
             $select->where->equalTo('id', $arrParam['id']);
         })->current();
     }
     if ($options['task'] == 'user-active') {
         return $result = $this->tableGateway->select(function (Select $select) use($arrParam) {
             $select->where->equalTo('id', $arrParam['id'])->where->equalTo('active_code', $arrParam['code']);
         })->count();
     }
     if ($options['task'] == 'restore-password') {
         return $result = $this->tableGateway->select(function (Select $select) use($arrParam) {
             $select->where->equalTo('fpass_code', $arrParam['code']);
         })->count();
     }
     if ($options['task'] == 'store-group-info') {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select();
         $select->from(array('u' => 'user_group'))->columns(array('id', 'group_name', 'group_acp', 'permission_id'));
         $select->where('u.id = ' . $arrParam['id']);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = $result[0];
         return $result;
     }
     return $row;
 }
예제 #15
0
 public function getItem($arrParam = null, $options = null)
 {
     if ($options['task'] == 'category-frontend') {
         $result = $this->tableGateway->select(function (Select $select) use($arrParam) {
             $select->columns(array('id', 'name', 'description', 'left', 'right'))->where->equalTo('id', $arrParam['id']);
         })->current();
         return $result;
     }
     if ($options['task'] == 'get-item') {
         $row = $this->tableGateway->select(array('id' => $arrParam['id']))->current();
         if (empty($row)) {
             return false;
         }
     }
     if ($options['task'] == 'get-item-find-parent-cat') {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select()->from('real_estate_type')->columns(array('parent'))->where('id = ' . $arrParam);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         return $result;
     }
     if ($options['task'] == 'get-item-category') {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select()->from('category')->where('id = ' . $arrParam['id']);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = $result[0];
         return $result;
     }
     if ($options['task'] == 'get-item-city') {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select()->from('city')->columns(array('id', 'name'))->where('id =' . $arrParam['cityid']);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = $result[0];
         return $result;
     }
     if ($options == null) {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select();
         $select->from(array('p' => 'project'))->join(array('ct' => 'city'), 'ct.id = p.city', array('name_city' => 'name'), $select::JOIN_LEFT)->join(array('ctd' => 'city_district'), 'ctd.id = p.district', array('name_district' => 'name'), $select::JOIN_LEFT)->join(array('b' => 'business'), 'b.id = p.investors', array('name_investors' => 'name', 'alias_investors' => 'alias'), $select::JOIN_LEFT)->join(array('b1' => 'business'), 'b1.id = p.construction', array('name_construction' => 'name', 'alias_construction' => 'alias'), $select::JOIN_LEFT)->join(array('b2' => 'business'), 'b2.id = p.management', array('name_management' => 'name', 'alias_management' => 'alias'), $select::JOIN_LEFT)->join(array('b3' => 'business'), 'b3.id = p.design', array('name_design' => 'name', 'alias_design' => 'alias'), $select::JOIN_LEFT)->join(array('b4' => 'business'), 'b4.id = p.distributors', array('name_distributors' => 'name', 'alias_distributors' => 'alias', 'logo_distributors' => 'logo'), $select::JOIN_LEFT)->join(array('retype' => 'category'), 'retype.id = p.cat_id', array('name_category' => 'name'), $select::JOIN_LEFT);
         $select->where('p.id =' . $arrParam['id']);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = $result[0];
         return $result;
     }
     return $row;
 }
예제 #16
0
 public function getItem($arrParam = null, $options = null)
 {
     if ($options['task'] == 'category-frontend') {
         $result = $this->tableGateway->select(function (Select $select) use($arrParam) {
             $select->columns(array('id', 'name', 'description', 'left', 'right'))->where->equalTo('id', $arrParam['id']);
         })->current();
         return $result;
     }
     if ($options['task'] == 'get-item') {
         $row = $this->tableGateway->select(array('id' => $arrParam['id']))->current();
         if (empty($row)) {
             return false;
         }
     }
     if ($options['task'] == 'get-item-find-parent-cat') {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select()->from('real_estate_type')->columns(array('parent'))->where('id = ' . $arrParam);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         return $result;
     }
     if ($options == null) {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select();
         $select->from(array('n' => 'news'))->columns(array('id', 'cat_id', 'title', 'description', 'content', 'images', 'city', 'status', 'date_time', 'order'));
         $select->where('n.id =' . $arrParam['id']);
         //echo $sqlString  = $sqlObj->getSqlStringForSqlObject($select);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = $result[0];
         return $result;
     }
     return $row;
 }
예제 #17
0
 public function getItem($arrParam = null, $options = null)
 {
     if ($options['task'] == 'category-frontend') {
         $result = $this->tableGateway->select(function (Select $select) use($arrParam) {
             $select->columns(array('id', 'name', 'description', 'left', 'right'))->where->equalTo('id', $arrParam['id']);
         })->current();
         return $result;
     }
     if ($options['task'] == 'get-item') {
         $row = $this->tableGateway->select(array('id' => $arrParam['id']))->current();
         if (empty($row)) {
             return false;
         }
     }
     if ($options['task'] == 'get-item-find-parent-cat') {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select()->from('category')->columns(array('parent'))->where('id = ' . $arrParam);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         return $result;
     }
     if ($options['task'] == 'get-item-fengshui') {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select()->from('fengshui')->columns(array('id', 'birth', 'sex', 'direction', 'content'));
         //Năm sinh
         $select->where('birth =' . $arrParam['feng-shui-birth']);
         if (!empty($arrParam['feng-shui-sex'])) {
             $select->where('sex =' . $arrParam['feng-shui-sex']);
         }
         if (!empty($arrParam['feng-shui-huong'])) {
             $select->where('direction =' . $arrParam['feng-shui-huong']);
         }
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = $result[0];
         return $result;
     }
     if ($options['task'] == 'get-item-city') {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select()->from('city')->columns(array('id', 'name'))->where('id =' . $arrParam['cityid']);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = $result[0];
         return $result;
     }
     if ($options == null) {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select();
         $select->from(array('re' => 'real_estate'))->join(array('ct' => 'city'), 'ct.id = re.city', array('name_city' => 'name'), $select::JOIN_LEFT)->join(array('ctd' => 'city_district'), 'ctd.id = re.district', array('name_district' => 'name'), $select::JOIN_LEFT)->join(array('ctdw' => 'city_district_ward'), 'ctdw.id = re.ward', array('name_ward' => 'name'), $select::JOIN_LEFT)->join(array('retype' => 'category'), 'retype.id = re.cat_id', array('name_type' => 'name'), $select::JOIN_LEFT)->join(array('project' => 'project'), 'project.id = re.project', array('name_project' => 'name'), $select::JOIN_LEFT)->join(array('u' => 'users'), 'u.id = re.user_id', array('fullname', 'phone', 'avatar'), $select::JOIN_LEFT)->join(array('ju' => 'juridical'), 'ju.id = re.juridical', array('name_juridical' => 'name'), $select::JOIN_LEFT)->join(array('status' => 'real_estate_status'), 'status.id = re.status', array('name_status' => 'name'), $select::JOIN_LEFT);
         $select->where('re.id =' . $arrParam['id']);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = $result[0];
         return $result;
     }
     if ($options['task'] == 'view-bds') {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select();
         $select->from(array('re' => 'real_estate_view'))->columns(array('id', 'real_estate_id', 'date_time', 'view'));
         $select->where('re.real_estate_id = ' . $arrParam['id']);
         $select->where('re.date_time = "' . $arrParam['date_time'] . '"');
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         if (!empty($result)) {
             $result = $result[0];
         }
         return $result;
     }
     return $row;
 }
예제 #18
0
 public function deleteItem($arrParam = null, $options = null)
 {
     if ($options['task'] == 'delete-item') {
         $this->tableGateway->delete(array('id' => $arrParam['id']));
         //Xóa xã, phường của quận. huyện
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select();
         $select->from('city_district')->where('city_id = ' . $arrParam['id']);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         foreach ($result as $value) {
             $deleteObj = $sqlObj->delete('city_district_ward');
             $deleteObj->where(new \Zend\Db\Sql\Predicate\In('district_id', array($value['id'])));
             $sqlString = $sqlObj->getSqlStringForSqlObject($deleteObj);
             $this->adapter->query($sqlString)->execute();
         }
         //Xóa quận, huyện của thành phố
         $sqlObj = new Sql($this->adapter);
         $deleteObj = $sqlObj->delete('city_district');
         $deleteObj->where(new \Zend\Db\Sql\Predicate\In('city_id', array($arrParam['id'])));
         $sqlString = $sqlObj->getSqlStringForSqlObject($deleteObj);
         $this->adapter->query($sqlString)->execute();
     }
     if ($options['task'] == 'delete-item-ward') {
         $sqlObj = new Sql($this->adapter);
         $deleteObj = $sqlObj->delete('city_district_ward');
         $deleteObj->where(new \Zend\Db\Sql\Predicate\In('id', array($arrParam['id'])));
         $sqlString = $sqlObj->getSqlStringForSqlObject($deleteObj);
         $this->adapter->query($sqlString)->execute();
     }
     if ($options['task'] == 'delete-item-district') {
         $sqlObj = new Sql($this->adapter);
         $deleteObj = $sqlObj->delete('city_district');
         $deleteObj->where(new \Zend\Db\Sql\Predicate\In('id', array($arrParam['id'])));
         $sqlString = $sqlObj->getSqlStringForSqlObject($deleteObj);
         $this->adapter->query($sqlString)->execute();
         //Xóa xã, phường của quận. huyện
         $deleteObj = $sqlObj->delete('city_district_ward');
         $deleteObj->where(new \Zend\Db\Sql\Predicate\In('district_id', array($arrParam['id'])));
         $sqlString = $sqlObj->getSqlStringForSqlObject($deleteObj);
         $this->adapter->query($sqlString)->execute();
     }
 }
예제 #19
0
 public function accessDate($totalCounter)
 {
     //Select dữ liệu truy cập của ngày hôm đó
     $select = $this->sqlObj->select();
     $select->from('statistics_access_date')->where('day = ' . $this->day)->where('month = ' . $this->month)->where('year = ' . $this->year);
     $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
     $result = !empty($result) ? $result[0] : null;
     //Nếu chưa có dữ liệu truy cập của ngày hôm đó thì tiến hành insert tổng số truy cập , ngày, tháng, năm
     if (empty($result['total_counter'])) {
         $data = array('total_counter' => $totalCounter, 'day' => $this->day, 'month' => $this->month, 'year' => $this->year);
         $insertObj = $this->sqlObj->insert('statistics_access_date');
         $insertObj->values($data);
         $sqlString = $this->sqlObj->getSqlStringForSqlObject($insertObj);
         $this->adapter->query($sqlString)->execute();
     } else {
         //Ngược lại tiến hành update tổng lượt truy cập
         $data = array('total_counter' => $totalCounter);
         $updateObj = $this->sqlObj->update('statistics_access_date');
         $updateObj->set($data);
         $updateObj->where('id = ' . $result['id']);
         $sqlString = $this->sqlObj->getSqlStringForSqlObject($updateObj);
         $this->adapter->query($sqlString)->execute();
     }
 }
예제 #20
0
 public function getItem($arrParam = null, $options = null)
 {
     if ($options['task'] == 'get-item') {
         $row = $this->tableGateway->select(array('id' => $arrParam['id']))->current();
         if (empty($row)) {
             return false;
         }
     }
     if ($options == null) {
         $row = $this->tableGateway->select(function (Select $select) use($arrParam) {
             $select->columns(array('id', 'username', 'fullname', 'email', 'birth'));
             $select->where->equalTo('id', $arrParam['id']);
         })->current();
         if (empty($row)) {
             return false;
         }
     }
     if ($options['task'] == 'get-item-with-id') {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select()->from(array('u' => 'user_ban'))->columns(array('nguyennhan'));
         $select->where('u.user_id =' . $arrParam['id']);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = !empty($result) ? $result[0] : '';
         return $result;
     }
     if ($options['task'] == 'get-item-with-ip') {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select()->from(array('u' => 'user_ban'))->columns(array('nguyennhan'));
         $select->where('u.ip = "' . $arrParam['ip'] . '"');
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = !empty($result) ? $result[0] : '';
         return $result;
     }
     return $row;
 }
예제 #21
0
 public function getItem($arrParam = null, $options = null)
 {
     if ($options['task'] == 'get-item') {
         $row = $this->tableGateway->select(array('id' => $arrParam['id']))->current();
         if (empty($row)) {
             return false;
         }
     }
     if ($options == null) {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select()->from(array('b' => 'business'))->columns(array('id', 'type_business', 'name', 'logo', 'address', 'city', 'district', 'ward', 'phone', 'fax', 'website', 'intro', 'contact', 'department', 'date_time', 'status', 'order', 'alias'));
         $select->join(array('ct' => 'city'), 'ct.id = b.city', array('name_city' => 'name'), $select::JOIN_LEFT);
         $select->join(array('ctd' => 'city_district'), 'ctd.id = b.district', array('name_district' => 'name'), $select::JOIN_LEFT);
         $select->join(array('ctdw' => 'city_district_ward'), 'ctdw.id = b.ward', array('name_ward' => 'name'), $select::JOIN_LEFT);
         $select->join(array('tb' => 'category'), 'tb.id = b.type_business', array('type_business' => 'name'), $select::JOIN_LEFT);
         if (!empty($arrParam['id'])) {
             $select->where('b.id =' . $arrParam['id']);
         }
         if (!empty($arrParam['alias'])) {
             $keywords = '%' . $arrParam['alias'] . '%';
             $select->where->like('b.alias', $keywords);
         }
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = $result[0];
         return $result;
     }
     return $row;
 }
예제 #22
0
 public function getItem($arrParam = null, $options = null)
 {
     if ($options['task'] == 'get-item') {
         $row = $this->tableGateway->select(array('id' => $arrParam['id']))->current();
         if (empty($row)) {
             return false;
         }
     }
     if ($options['task'] == 'get-item-find-parent-cat') {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select()->from('category')->columns(array('parent'))->where('id = ' . $arrParam);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         return $result;
     }
     if ($options == null) {
         $row = $this->tableGateway->select(function (Select $select) use($arrParam) {
             $select->columns(array('id', 'username', 'fullname', 'email', 'birth'));
             $select->where->equalTo('id', $arrParam['id']);
         })->current();
         if (empty($row)) {
             return false;
         }
     }
     if ($options['task'] == 'get-item-statistic-service') {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select()->from('users')->columns(array('id', 'info_service_account'));
         $select->where('id = ' . $arrParam);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = $result[0];
         return $result;
     }
     if ($options['task'] == 'staff') {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select()->from('users')->columns(array('id'))->where('parent = "' . $arrParam['id'] . '"');
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         return $result;
     }
     return $row;
 }
예제 #23
0
 public function getItem($arrParam = null, $options = null)
 {
     if ($options['task'] == 'get-item') {
         $row = $this->tableGateway->select(array('id' => $arrParam['id']))->current();
         if (empty($row)) {
             return false;
         }
     }
     if ($options['task'] == 'get-item-city') {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select()->from('city')->columns(array('id', 'name'))->where('id =' . $arrParam['cityid']);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = $result[0];
         return $result;
     }
     if ($options['task'] == 'get-item-district') {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select()->from('city_district')->columns(array('id', 'name'))->where('id =' . $arrParam['iddistrict']);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = $result[0];
         return $result;
     }
     return $row;
 }
 public function getItem($arrParam = null, $options = null)
 {
     if ($options['task'] == 'category-frontend') {
         $result = $this->tableGateway->select(function (Select $select) use($arrParam) {
             $select->columns(array('id', 'name', 'description', 'left', 'right'))->where->equalTo('id', $arrParam['id']);
         })->current();
         return $result;
     }
     if ($options['task'] == 'get-item') {
         $row = $this->tableGateway->select(array('id' => $arrParam['id']))->current();
         if (empty($row)) {
             return false;
         }
     }
     if ($options['task'] == 'get-item-cat') {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select()->from('category')->columns(array('name'))->where('type = "category_legislationhousing"')->where('id = ' . $arrParam['id']);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = $result[0];
         return $result;
     }
     if ($options == null) {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select();
         $select->from(array('l' => 'legislation_housing'));
         $select->where('l.id =' . $arrParam['id']);
         //echo $sqlString  = $sqlObj->getSqlStringForSqlObject($select);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = $result[0];
         return $result;
     }
     return $row;
 }
예제 #25
0
 public function getItem($arrParam = null, $options = null)
 {
     if ($options['task'] == 'get-item') {
         $row = $this->tableGateway->select(array('id' => $arrParam['id']))->current();
         if (empty($row)) {
             return false;
         }
     }
     if ($options['task'] == 'view-send') {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select()->from('message_send');
         $select->join(array('u' => 'users'), 'u.id = message_send.user_id_receive', array('fullname' => 'fullname'), $select::JOIN_LEFT);
         $select->where('message_send.id =' . $arrParam['id']);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = $result[0];
         return $result;
     }
     if ($options['task'] == 'view-receive') {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select()->from('message_receive');
         $select->join(array('u' => 'users'), 'u.id = message_receive.user_id_send', array('fullname' => 'fullname'), $select::JOIN_LEFT);
         $select->where('message_receive.id =' . $arrParam['id']);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = $result[0];
         return $result;
     }
     if ($options['task'] == 'check-username') {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select()->from('users')->columns(array('id'))->where('username ="******"');
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         return $result;
     }
     return $row;
 }
 public function getItem($arrParam = null, $options = null)
 {
     if ($options['task'] == 'get-item') {
         $row = $this->tableGateway->select(array('id' => $arrParam['id']))->current();
         if (empty($row)) {
             return false;
         }
     }
     if ($options == null) {
         $sqlObj = new Sql($this->adapter);
         $select = $sqlObj->select();
         $select->from(array('re' => 'real_estate'))->join(array('ct' => 'city'), 'ct.id = re.city', array('name_city' => 'name'), $select::JOIN_LEFT)->join(array('ctd' => 'city_district'), 'ctd.id = re.district', array('name_district' => 'name'), $select::JOIN_LEFT)->join(array('ctdw' => 'city_district_ward'), 'ctdw.id = re.ward', array('name_ward' => 'name'), $select::JOIN_LEFT)->join(array('retype' => 'category'), 'retype.id = re.cat_id', array('name_type' => 'name'), $select::JOIN_LEFT)->join(array('project' => 'project'), 'project.id = re.project', array('name_project' => 'name'), $select::JOIN_LEFT)->join(array('u' => 'users'), 'u.id = re.user_id', array('fullname', 'phone', 'avatar'), $select::JOIN_LEFT)->join(array('ju' => 'juridical'), 'ju.id = re.juridical', array('name_juridical' => 'name'), $select::JOIN_LEFT)->join(array('status' => 'real_estate_status'), 'status.id = re.status', array('name_status' => 'name'), $select::JOIN_LEFT);
         $select->where('re.id =' . $arrParam['id']);
         $result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
         $result = $result[0];
         return $result;
     }
     return $row;
 }