public function act_changeOstatusId() { $ostatus = $_POST['ostatus']; $list = $this->sql("SELECT * FROM " . C('DB_PREFIX') . "status_menu WHERE groupId='{$ostatus}' AND is_delete=0")->select(array('mysql')); self::$errCode = StatusMenuModel::$errCode; self::$errMsg = StatusMenuModel::$errMsg; if ($list) { return $list; } else { return false; } }
/** * 根据状态获取读取状态列表(最新版) * last modified by Herman.Xi @20131205 $ @where as String */ public static function getOrderNameByStatus($ostatus, $otype, $storeId = 1) { self::initDB(); if (!$ostatus && !$otype) { //预防状态不选择,如何选择分表搜索的情况@20140226 return 'om_unshipped_order'; } $select = 'oType'; //echo $ostatus.'--'.$otype; if ($otype) { $where = ' where statusCode = ' . $otype; } else { $where = ' where statusCode = ' . $ostatus; } $where .= ' and storeId = ' . $storeId . ' and is_delete = 0 '; $sql = "select {$select} from " . self::$table . " {$where} "; $query = self::$dbConn->query($sql); if ($query) { $ret = self::$dbConn->fetch_array($query); if ($ret['oType'] == 1) { $orderTable = 'om_unshipped_order'; } else { $orderTable = 'om_shipped_order'; } return $orderTable; //成功, 返回列表数据 } else { self::$errCode = "003"; self::$errMsg = "error"; return false; } }