/** * WhWaveAreaInfoModel::get_area_info() * 获取区域信息 * @param mixed $select 查询字段 多个字段数组,单个字符串即可 * @param array $area_ids 区域ID 多个字段数组,单个字符串即可 * @param array $areaName 区域名称 多个字段数组,单个字符串即可 * @return */ public static function get_area_info($select, $area_ids = '', $areaName = '') { self::initDB(); $tableName = self::$tablename; $select = array2select($select); $sql = "select {$select} from {$tableName} where "; if ($area_ids) { $area_ids = is_array($area_ids) ? array_unique($area_ids) : $area_ids; //$area_ids = array2select($area_ids); //$area_ids = str_replace('`', "'", $area_ids); $area_ids = is_array($area_ids) ? implode("','", $area_ids) : $area_ids; $sql .= "id in ('{$area_ids}') and "; } if ($areaName) { $areaName = is_array($areaName) ? array_unique($areaName) : $areaName; //$areaName = array2select($areaName); //$areaName = str_replace('`', "'", $areaName); $areaName = is_array($areaName) ? implode("','", $areaName) : $areaName; $sql .= "areaName in ('{$areaName}') and "; } //echo $sql; $sql .= 'is_delete = 0'; $sql = self::$dbConn->query($sql); $res = self::$dbConn->fetch_array_all($sql); return $res; }
/** * whWaveMultiShipAreaRecordModel::get_multi_ship_records() * 获取多料号订单区域临时信息 * @param array $select 查询字段 多个数组,单个字符串 * @param array $where 数组 * @author Gary * @return $res */ public static function get_multi_ship_records($select, $where) { self::initDB(); $select = array2select($select); $where = array2where($where); $sql = "select {$select} from " . self::$tablename . " where {$where}"; //echo $sql;exit; $sql = self::$dbConn->query($sql); $res = self::$dbConn->fetch_array_all($sql); return $res; }
/** * WhShippingOrderModel::get_order_info() * 获取发货单信息 * @param array $select 多个数组,单个字符 * @param array $where 条件数组 * @param bool $fetch_one 是否只获取一条记录 * @author Gary * @return void */ public static function get_order_info($select, $where, $fetch_one = FALSE) { self::initDB(); $select = array2select($select); $where = array2where($where); $sql = "select {$select} from " . self::$tablename . " where {$where} and is_delete = 0"; $sql = self::$dbConn->query($sql); $func = $fetch_one ? 'fetch_array' : 'fetch_array_all'; $res = self::$dbConn->{$func}($sql); return $res; }
/** * WhWaveAreaUserRelationModel::get_user_by_areaName() * * @param mixed $areas * @return void */ public static function get_user_by_areaName($areas) { self::initDB(); $areas = array2select($areas); $areas = str_replace(',', "','", $areas); $sql = "select a.areaName as area,c.global_user_name as user from wh_wave_area_info a left join wh_wave_area_user_relation b\n on a.id = b.areaId left join power_global_user c on c.global_user_id = b.userId where a.areaName in ('{$areas}')"; //echo $sql;exit; $sql = self::$dbConn->query($sql); $res = self::$dbConn->fetch_array_all($sql); return $res; }
/** * WhOrderPartionPrintDHLModel::get_packageInfo() * 获取新加坡DHL口袋信息 * @param mixed $select * @param mixed $where * @param bool $fetch_row * @return void */ public static function get_packageInfo($select, $where, $fetch_row = FALSE) { self::initDB(); $select = array2select($select); $where = array2where($where); $sql = "select {$select} from " . self::$tablename . ' where ' . $where; $sql = self::$dbConn->query($sql); $fetch = $fetch_row ? 'fetch_array' : 'fetch_array_all'; $res = self::$dbConn->{$fetch}($sql); return $res; }
/** * WhWaveInfoModel::get_wave_info_by_union_table() * 联表查询配货单信息(配货单管理界面查询功能) * @param mixed $select * @param array $where * @return void */ public static function get_wave_info_by_union_table($select, $where) { self::initDB(); $select = array2select($select); $where = array2where($where); $sql = 'select ' . $select . ' from wh_wave_info a left join wh_wave_receive_record c on c.waveId = a.id left join wh_wave_area_info b on b.areaName = c.area left join wh_wave_area_user_relation d on d.areaId = b.id where ' . $where; //echo $sql; $sql = self::$dbConn->query($sql); $res = self::$dbConn->fetch_array_all($sql); return $res; }
/** * PcGoodsModel::get_sku_info() * 查询料号信息 * @param array|string $select 查询字段 * @param array $skuArr 查询的料号集合 * @return */ public static function get_sku_info($select, $skuArr) { self::initDB(); $select = trim(array2select($select)); //$skuArr = trim(array2select($skuArr)); //$skuArr = str_replace('`', '\'', $skuArr); $skuArr = implode("','", $skuArr); if (!$select || !$skuArr) { return FALSE; } $sql = "select {$select} from pc_goods where sku in ('{$skuArr}') and is_delete = 0"; //echo $sql;exit; $sql = self::$dbConn->query($sql); $res = self::$dbConn->fetch_array_all($sql); return $res; }
/** * WhPositionDistributionModel::get_position_info() * 获取仓位信息 * @param $select 查询字段 数组 * @param array $position_ids 仓位id集合 多个数组 单个string * @param $pName 字符串 * @return void */ public static function get_position_info($select, $position_ids = '', $pName = '') { self::initDB(); $tableName = self::$tablename; $select = array2select($select); $sql = "select {$select} from {$tableName} where "; if (!empty($position_ids)) { $position_ids = is_array($position_ids) ? array_unique($position_ids) : $position_ids; $position_ids = array2select($position_ids); $position_ids = str_replace('`', "'", $position_ids); $sql .= "id in ({$position_ids}) and "; } if ($pName) { $sql .= "pName = '{$pName}' and "; } $sql .= 'id > 0'; //echo $sql;exit; $sql = self::$dbConn->query($sql); $res = self::$dbConn->fetch_array_all($sql); return $res; }
/** * whShelfModel::selectTallyingList() * 获取点货信息 * @param array or string $seelct * @param array $where */ public static function selectTallyingList($select, $where) { self::initDB(); $select = array2select($select); $where = array2where($where); $where .= $where ? ' and is_delete = 0' : ' is_delete = 0'; $sql = "select {$select} from wh_tallying_list where " . $where; $sql = self::$dbConn->query($sql); $res = self::$dbConn->fetch_array_all($sql); return $res; }
public static function select($where = '1=1', $fields = '*') { self::initDB(); //$wheresql[] = ' where'; // if(!$where){ // $where = "1=1"; // } //if(is_numeric($where)){ // $wheresql[] = 'id='.$where; // }else if(is_array($where)){ // foreach($where as $key => $val){ // $whereArr[] = $key."='".$val."'"; // } // $wheresql[] = implode(' AND ', $whereArr); // }else{ // $wheresql[] = $where; // } $where = array2where($where); $fields = array2select($fields); $sql = "select {$fields} from " . self::$tablename . ' where ' . $where; //echo $sql;exit; $query = self::$dbConn->query($sql); if ($query) { $ret = self::$dbConn->fetch_array_all($query); return $ret; //成功, 返回数据 } else { self::$errCode = "001"; self::$errMsg = "获取数据失败"; return false; //失败则设置错误码和错误信息, 返回false } }
/** * WhIoRecordsModel::selectIoRecords() * 获取出入库表记录 * @author Gary * @return void */ public static function selectIoRecords($select, $where) { self::initDB(); $select = array2select($select); $where = array2where($where); $sql = 'SELECT ' . $select . ' from wh_iorecords where ' . $where; //echo $sql;exit; $sql = self::$dbConn->query($sql); $res = self::$dbConn->fetch_array_all($sql); return $res; }