[技术交流] ECSHOP 后@台状态SQL查询 [复制链接]
查看:2503 | 回复:2

6688 · 发表于 2015-5-26 06:56:39

本帖最后由 6688 于 2015-5-26 07:00 编辑

/* 待付款订单 */
elseif ($type == 'await_pay')
{
return " AND {$alias}order_status " . db_create_in(array(OS_CONFIRMED, OS_SPLITED)) .
" AND {$alias}pay_status = '" . PS_UNPAYED . "'" .
" AND ( {$alias}shipping_status " . db_create_in(array(SS_SHIPPED, SS_RECEIVED)) . " OR {$alias}pay_id " . db_create_in(payment_id_list(false)) . ") ";
}

复制代码

上面是ecshop待付款订单列表数据查询.我想要加在个查询sign_building这个字段里的"称重".查询sign_building,有"称重"这两字,就和待付款订单列出来.只要改上面的查询就判断就可以.谢谢啦.

Google_Adsense · 发表于 2015-5-26 06:56:40

/* 待付款订单 */
elseif ($type == 'await_pay')
{
return " AND {$alias}order_status " . db_create_in(array(OS_CONFIRMED, OS_SPLITED)) .
" AND {$alias}pay_status = '" . PS_UNPAYED . "'" .
" AND {$alias}sign_building like '%称重%'" .
" AND ( {$alias}shipping_status " . db_create_in(array(SS_SHIPPED, SS_RECEIVED)) . " OR {$alias}pay_id " . db_create_in(payment_id_list(false)) . ") ";
}

复制代码

正如楼上所说，很可能没用，因为我不知道你所说的sign_building和这个代码所查询的表是不是在一个表里面

iceteaa · 发表于 2015-5-26 09:09:00

没用的不在这里