深圳智汇创想科技有限公司

修改了 Bug标题，区别为：

001- 自动刊登队列-符合策略条件的113条，实际未执行出数据
001+ 自动刊登队列-策略条件-产品侵权风险验证，符合策略条件的113条，实际未执行出数据

001- 自动刊登队列-符合策略条件的113条，实际未执行出数据
001+ 自动刊登队列-策略条件-产品侵权风险验证，符合策略条件的113条，实际未执行出数据

修改了 重现步骤，区别为：

002-
002+
003- 符合条件的数据
003+
004- ```
004+ 符合条件的数据
005- SELECT rp.id, rp.customer_id AS customerId, rp.sku AS sku, rp.product_group_sku AS productGroupSku, rp.last_supplier_price AS lastSupplierPrice, rp.last_buy_price AS lastBuyPrice, rp.market_price AS marketPrice, rp.last_buy_ship_fee AS lastBuyShipFee, rp.add_time AS addTime , rp.product_state, rp.product_propertyFROM `zhcxkj-center-product`.rb_product rp JOIN `zhcxkj-center-product`.rb_product_admin rpa ON rpa.customer_id = rp.customer_id AND rpa.sku = rp.sku AND rpa.check_status = 1WHERE rp.customer_id = 1 AND rp.class_id IN ( 4711 ) AND rp.is_group=0 AND rp.is_main_group_sku=1 AND rp.product_state=0 AND rp.product_property=1 ORDER BY rp.add_time DESC
005+ ```
006- ```
006+ SELECT rp.id, rp.customer_id AS customerId, rp.sku AS sku, rp.product_group_sku AS productGroupSku, rp.last_supplier_price AS lastSupplierPrice, rp.last_buy_price AS lastBuyPrice, rp.market_price AS marketPrice, rp.last_buy_ship_fee AS lastBuyShipFee, rp.add_time AS addTime , rp.product_state, rp.product_propertyFROM `zhcxkj-center-product`.rb_product rp JOIN `zhcxkj-center-product`.rb_product_admin rpa ON rpa.customer_id = rp.customer_id AND rpa.sku = rp.sku AND rpa.check_status = 1WHERE rp.customer_id = 1 AND rp.class_id IN ( 4711 ) AND rp.is_group=0 AND rp.is_main_group_sku=1 AND rp.product_state=0 AND rp.product_property=1 ORDER BY rp.add_time DESC
007-
007+ ```
008- 实际结果：
008+
009-
009+ 实际结果：
010+

002- <p><img src="{233322.png}" alt="" /></p>
002+ <p><img src="{233411.png}" alt="" /></p>
003- <p>符合条件的数据</p>
003+ <p><img src="{233412.png}" alt="" /></p>
004- <p>```</p>
004+ <p>符合条件的数据</p>
005- <p><br />SELECT<br /><span> </span>rp.id,<br /><span> </span>rp.customer_id AS customerId,<br /><span> </span>rp.sku AS sku,<br /><span> </span>rp.product_group_sku AS productGroupSku,<br /><span> </span>rp.last_supplier_price AS lastSupplierPrice,<br /><span> </span>rp.last_buy_price AS lastBuyPrice,<br /><span> </span>rp.market_price AS marketPrice,<br /><span> </span>rp.last_buy_ship_fee AS lastBuyShipFee,<br /><span> </span>rp.add_time AS addTime ,<br /><span> </span>rp.product_state,<br /><span> </span>rp.product_property<br />FROM<br /><span> </span>`zhcxkj-center-product`.rb_product rp<br /><span> </span>JOIN `zhcxkj-center-product`.rb_product_admin rpa ON rpa.customer_id = rp.customer_id<br /><span> </span>AND rpa.sku = rp.sku<br /><span> </span>AND rpa.check_status = 1<br />WHERE<br /><span> </span>rp.customer_id = 1<br /><span> </span>AND rp.class_id IN ( 4711 )<br /><span> </span>AND rp.is_group=0<br /><span> </span>AND rp.is_main_group_sku=1<br /><span> </span>AND rp.product_state=0<br /><span> </span>AND rp.product_property=1<br /><span> </span>ORDER BY rp.add_time DESC</p>
005+ <p>```</p>
006- <p>```</p>
006+ <p><br />SELECT<br /><span> </span>rp.id,<br /><span> </span>rp.customer_id AS customerId,<br /><span> </span>rp.sku AS sku,<br /><span> </span>rp.product_group_sku AS productGroupSku,<br /><span> </span>rp.last_supplier_price AS lastSupplierPrice,<br /><span> </span>rp.last_buy_price AS lastBuyPrice,<br /><span> </span>rp.market_price AS marketPrice,<br /><span> </span>rp.last_buy_ship_fee AS lastBuyShipFee,<br /><span> </span>rp.add_time AS addTime ,<br /><span> </span>rp.product_state,<br /><span> </span>rp.product_property<br />FROM<br /><span> </span>`zhcxkj-center-product`.rb_product rp<br /><span> </span>JOIN `zhcxkj-center-product`.rb_product_admin rpa ON rpa.customer_id = rp.customer_id<br /><span> </span>AND rpa.sku = rp.sku<br /><span> </span>AND rpa.check_status = 1<br />WHERE<br /><span> </span>rp.customer_id = 1<br /><span> </span>AND rp.class_id IN ( 4711 )<br /><span> </span>AND rp.is_group=0<br /><span> </span>AND rp.is_main_group_sku=1<br /><span> </span>AND rp.product_state=0<br /><span> </span>AND rp.product_property=1<br /><span> </span>ORDER BY rp.add_time DESC</p>
007- <p><img src="{233326.png}" alt="" /></p>
007+ <p>```</p>
008- <p>实际结果：</p>
008+ <p><img src="{233326.png}" alt="" /></p>
009- <p><img src="{233329.png}" alt="" /></p>
009+ <p>实际结果：</p>
010+ <p><img src="{233329.png}" alt="" /></p>

修改了 解决方案，旧值为 ""，新值为 "code"。
修改了 解决版本，旧值为 ""，新值为 "645"。
修改了 解决日期，旧值为 ""，新值为 "2022-12-19 17:39:41"。
修改了 指派给 ，旧值为 "jialipeng"，新值为 "yanfeng"。
修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
修改了 是否确认，旧值为 "0"，新值为 "1"。
修改了 解决者 ，旧值为 ""，新值为 "jialipeng"。

修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
修改了 指派给 ，旧值为 "yanfeng"，新值为 "closed"。
修改了 由谁关闭，旧值为 ""，新值为 "yanfeng"。
修改了 关闭日期，旧值为 ""，新值为 "2022-12-19 19:20:03"。

修改了 所属模块，旧值为 "1808"，新值为 "1876"。