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;
}
}
