国产av日韩一区二区三区精品,成人性爱视频在线观看,国产,欧美,日韩,一区,www.成色av久久成人,2222eeee成人天堂

php - ? SQL? ????? ??? ??????
世界只因有你
世界只因有你 2017-05-16 13:13:12
0
2
969

< /p>

sql語句是：
SELECT bp.amount / (yd_order_product?? count(*) ??, ??? order = bp.order ? product = bp.product)? ?????. ) ??, s.costprice, ??, s.store,b.type yd_batch_product?? bp ???? yd_order_product? op.order =?? op? ?? bp.order ? op.product = bp.product ??? bp.batch = b.id?? yd_batch? b? ???? ??? bp.order = o .id?? yd_order? o? ???? ??? bp.product = s.id?? yd_stock? s? ?????. ??? o.deleted = '0' ? s.forbidden = '0' ? '2015-10-13 ??? b.createdDate 00:00:00' ? '2017-04-30 23:59:59' ? s.store in (1,2,3,4,5,6) ? s.chainID = 1

?? ??? ?? ??? ??

世界只因有你
世界只因有你

?? ??(2)
巴扎黑

@TroyLiu ?? ??? ???? ?? ?? ???? ??/??/??/?? ?? ???? ????? ????? ??? ? ??? ????.

SQL ???? ?? ????? ???? ???? ?? where ?? ??? ?? ???? ???? ? ??? ????. ? ????
yd_batch_product ???? ?? ?? ??? where ??? ??? ??? ?? ?? ???? ?????.

"Using temporary; Using filesort"? ???? ??? group by? ??? ? ?? ??? yd_batch_product ???? ?? ??? ??? ???? ?? ?????.

?? ??:
1.yd_batch/yd_order/yd_stock? LEFT JOIN? ????? where ?? ??? ??? ??? ?? ?? ??? ???? INNER JOIN? ????? ?? ??? INNER JOIN?? ??? ? ???? mysql ?? ??? ??? ? yd_batch_product ???? ?? ??? ?? ????.
2. yd_batch ???? CreateDate ??? ???? ???? ?? ??? ? ?? ???? ???? ?? ??? ??? ?????. .
3. ??? ???? ?? store? chainID? ???? ??? yd_stock ???? ??? ???? ???? ?? ??? ??? ???? ?? ??? ?????? ??? ? ????.

??, ?? ???? ??? ????? ????? ????, ??? ???? ???? ? ?? yd_batch_product ????? ??? ??? ?, ? ??? ???? ???? ???? ????. ?? ??, yd_batch ???? CreateDate ???? yd_batch_product ????? ??? ?? ??? ??? ? ??? ???? ???? ? ?????.

?? ???? ? ?? ??:
1. TYPE=ALL? ?? ??? ??? ???? ?????. ?? CreateDate? ?? ???? ????? ?????? ????? ?? ??? ??? ???? ?? ? ???? ????? ???? ?????. 1? ??? ???, ? 10,000? ??? ??? ???? ? ? ?? ??). ???? ????? ?? ?? ??? ??? ?? ??? ?? ??? ??? ???? ???. ?? ????? ???? ??? ??? ??? ?? ??? ???? ??? ?? ?? ????.
2. yd_order_product ???? ? ? ????, ?? ?? ??? ?? ?? ??? ??? ??? ???.

阿神

?? yd_batch_product ???? ??? ?? ?? ??, ???? ??? ???? ?? ?? ???? ???? ???? ??? ??? ?????.
??? bp? ?? ? ?? ?? bp? NULL?? ? ? ????.

??? ??:

  1. yd_batch_product ???? order/product/batch/amount ?? ?? ???? ?????. ?? ??? ??? ?????. (??? ???? ????? ???? ??? ?????.)

  2. yd_batch_product? ?? ?? ??? ??? ???? ?? ?? ? ???? ???? ?? ????.

  3. yd_stock ???? allowed/store/chainID ?? ???? ??? ?????(??? ?? ??).

  4. yd_order ???? ??? ?? ?? ? ???? ?????.

  5. yd_batch ???? CreateDate ?? ?? ? ???? ?????.

?? ??? ???? ?? ???? ??? ? ????.
???? ?????? ?? ??? ??? ??? ??????.