{ if($search) { $search .= ' and (`'.global_mapping::ProductName.'` like \'%'.global_common::escape_mysql_string($keyword).'%\' or `'.global_mapping::Description.'` like \'%'.global_common::escape_mysql_string($keyword).'%\')' ; } else { $search .= '(`'.global_mapping::ProductName.'` like \'%'.global_common::escape_mysql_string($keyword).'%\' or `'.global_mapping::Description.'` like \'%'.global_common::escape_mysql_string($keyword).'%\')' ; } } */ if ($catID) { $searchGroup = global_mapping::ArticleTypeID . '= \'' . $catID . '\''; } $allProperties = $objProperty->getPropertyByCat($catID, 0, $total); $allDataTypes = $objDataType->getAllDatatype(); $allGroups = $objGroup->getAllPropertyGroup(0, '', $searchGroup, ''); $_SESSION[global_common::SES_C_CUR_PAGE] = "admin/admin_property.php"; include_once 'include/_admin_header.inc'; ?> <script type="text/javascript" src="<?php echo $_objSystem->locateJs('user_property.js'); ?> "></script> <div id="admin-property" class="admin-page"> <div class="row-fluid"> <div class="span12"> <!-- BEGIN PAGE TITLE & BREADCRUMB--> <h3 class="page-title"> Manage Property </h3>
public function getAllProperty($intPage = 0, $selectField = '*', $whereClause = '', $orderBy = '') { if ($whereClause) { $whereClause = ' WHERE ' . $whereClause; } if ($orderBy) { $orderBy = ' ORDER BY ' . $orderBy; } if ($intPage > 0) { $strSQL .= global_common::prepareQuery(global_common::SQL_SELECT_FREE, array($selectField, Model_Property::TBL_SL_PROPERTY, $whereClause . $orderBy . ' limit ' . ($intPage - 1) * self::NUM_PER_PAGE . ',' . self::NUM_PER_PAGE)); } else { $strSQL .= global_common::prepareQuery(global_common::SQL_SELECT_FREE, array($selectField, Model_Property::TBL_SL_PROPERTY, $whereClause . $orderBy)); } //echo '<br>SQL:'.$strSQL; $arrResult = $this->_objConnection->selectCommand($strSQL); if (!$arrResult) { global_common::writeLog('get All sl_property:' . $strSQL, 1, $_mainFrame->pPage); return null; } $objDataType = new Model_Datatype($this->_objConnection); $allDataType = $objDataType->getAllDatatype(); $dataTypes = array(); foreach ($allDataType as $key => $info) { $dataTypes[$info[global_mapping::DataTypeID]] = $info; unset($dataTypes[$key]); } $count = count($arrResult); for ($index = 0; $index < $count; $index++) { $arrResult[$index][global_mapping::DataTypeID] = $dataTypes[$arrResult[$index][global_mapping::DataTypeID]]; } //print_r($arrResult); return $arrResult; }