亚马逊问答系统自动上QA

qa内容：

asin：B0xxxxxxxxxx

Q：27895
Can this skin tag remover be applied to the area between my two toes where there is a wart? It causes me a lot of pain when I walk, and many products on the market can't reach this area. This has been bothering me.

A：
I can tell you very clearly that this skin tag removal kit can easily reach such an area, because it comes with a great brush! You just need to use the brush that comes with the wart remover to apply it to the targeted area. Apply it in small amounts multiple times, and the liquid won't flow everywhere! But one very important thing is that the strongest wart remover is fluid. When you find that you've applied too much liquid, you must promptly wipe off the liquid that has flowed onto the healthy skin in a timely manner to avoid causing discomfort, because it's really potent, haha.

　　

数据模型

 

表单查询代码配置：

<!-- 数据表单查询区域Html代码 begin-->
                站点:<input type="text" class="fsbpmserachcontrol search_txt" myts="txt" mykey="site" mycalc="equals"/>
                asin:<input type="text" class="fsbpmserachcontrol search_txt" myts="txt" mykey="asin" mycalc="like"/>
                <!-- 数据表单查询区域Html代码 end-->

　　

底部代码配置：

<!----------------------------- 数据表单底部区域Html代码 begin ----------------------------------------------------->
            <div class="div_bottom_control_location_area" align="left" style="text-align: left;width: 60%;font-size: 13px;display: none;" id="div_notes_for_all">
                <div id="div_op">
                    操作说明： 选择xlsx文件直接导入即可。
                    <button id="btn_cont_close" type="button" class="am-btn am-btn-sm am-btn-primary">Close</button>
                    <br/>
                    <a style='font-size:16px;color:blue;' href='http://4xxxxXKExj.xlsx'>下载导入模板</a>
                </div>
            </div>
            <script>
                $(".btn_import_xlsx_file_portal_list_head").hover(function () {
                    $("#div_notes_for_all").show();
                });
                $("#btn_cont_close").click(function () {
                    $("#div_notes_for_all").hide();
                });
            </script>
            <!----------------------------- 数据表单底部区域Html代码 begin ----------------------------------------------------->

　　

JS代码配置：

//-------------------------js begin--------------------------
            sort = "update_time  desc";

            function get_portal_data_list_done_back() {
                $("#listprodata").find(".bind_extension_x_asin").click(function () {
                    var val = $(this).html();
                    if (val !== null && val !== undefined && val.startsWith("http")) {
                        window.open(val);
                    } else if (val.length === 10 && val.startsWith("B0")) {
                        var url_asin_detail = "https://amazon.com/dp/" + val;
                        window.open(url_asin_detail);
                    } else {
                    }
                });
            }

            function do_something_before_delete_data_in_portal_list(id) {
                var bind_extension_x_state_val = $("#tr_data_" + id).find(".bind_extension_x_state").html();
                if (bind_extension_x_state_val !== "") {
                    alert("该数据已执行，不能删除！");
                    return false;
                }
                return true;
            }
            
            //-------------------------js end--------------------------

　　

python执行代码part：

def op_account_less_zero(arr_account):
    webhook.modify_by_sql_and_table_id("update table_id set update_date=now(),login_date=now(),effect_qa='-1',update_time=now() where id='%s'" % arr_account[0]["id"], table_id_dp_account)

def op_account_dns_error(arr_account):
    webhook.modify_by_sql_and_table_id("update table_id set update_date=now(),effect='0',effect_qa='-2',update_time=now(),machine_remarks='network timeout'  where id='%s'" % arr_account[0]["id"], table_id_dp_account)

def op_account_can_qa(arr_account):
    webhook.modify_by_sql_and_table_id("update table_id set update_date=now(),effect_qa='1',last_qa_time=now(),update_time=now(),machine_remarks='ok' where id='%s'" % arr_account[0]["id"], table_id_dp_account)

def op_account_can_not_qa(arr_account):
    webhook.modify_by_sql_and_table_id("update table_id set update_date=now(),effect_qa='0',update_time=now() where id='%s'" % arr_account[0]["id"], table_id_dp_account)

def op_account_can_not_msg_with_rmk(arr_account, rmk):
    rmk = str(rmk).replace("'", "").replace('"', '')
    if len(rmk) > 400:
        rmk = rmk[0:400]
    webhook.modify_by_sql_and_table_id("update table_id set update_date=now(),effect_qa='0',machine_remarks='" + rmk + "',update_time=now() where id='%s'" % arr_account[0]["id"], table_id_dp_account)

　　

 

ok for use:

 

done