<?php

$updatesql = "UPDATE wipwholestatus 
    SET
        building_heigh_verify = '$building_heigh_verify',
        building_heigh_verify_at = '$building_heigh_verify_at',
        building_heigh_verify_owner = '$building_heigh_verify_owner',
        site_survey_contact_verify = '$site_survey_contact_verify',
        site_survey_contact_verify_at = '$site_survey_contact_verify_at',
        site_survey_contact_verify_owner = '$site_survey_contact_verify_owner',
        sales_spec_verify = '$sales_spec_verify',
        sales_spec_verify_at = '$sales_spec_verify_at',
        sales_spec_verify_owner = '$sales_spec_verify_owner',
        customer_color_verify = '$customer_color_verify',
        customer_color_verify_at = '$customer_color_verify_at',
        customer_color_verify_owner = '$customer_color_verify_owner',
        customer_style_verify = '$customer_style_verify',
        customer_style_verify_at = '$customer_style_verify_at',
        customer_style_verify_owner = '$customer_style_verify_owner',
        site_survey_contact_form_verify = '$site_survey_contact_form_verify',
        site_survey_contact_form_verify_at = '$site_survey_contact_form_verify_at',
        site_survey_contact_form_verify_owner = '$site_survey_contact_form_verify_owner',
        delivery_date = '$delivery_date',
        delivery_date_owner = '$delivery_date_owner',
        customer_planning_verify = '$customer_planning_verify',
        customer_planning_verify_at = '$customer_planning_verify_at',
        customer_planning_verify_owner = '$customer_planning_verify_owner',
        association_check_type = '$association_check_type',
        desin_leader_verify = '$desin_leader_verify',
        desin_leader_verify_at = '$desin_leader_verify_at',
        desin_leader_verify_owner = '$desin_leader_verify_owner',
        desin_spec_verify = '$desin_spec_verify',
        desin_spec_verify_at = '$desin_spec_verify_at',
        desin_spec_verify_owner = '$desin_spec_verify_owner',
        desin_planning_verify = '$desin_planning_verify',
        desin_planning_verify_at = '$desin_planning_verify_at',
        desin_planning_verify_owner = '$desin_planning_verify_owner',
        desin_color_verify = '$desin_color_verify',
        desin_color_verify_at = '$desin_color_verify_at',
        desin_color_verify_owner = '$desin_color_verify_owner',
        desin_style_verify = '$desin_style_verify',
        desin_style_verify_at = '$desin_style_verify_at',
        desin_style_verify_owner = '$desin_style_verify_owner',
        desin_taiwan_items_no = '$desin_taiwan_items_no',
        desin_taiwan_items_name = '$desin_taiwan_items_name',
        prattford_order_date_verify = '$prattford_order_date_verify',
        prattford_order_date = '$prattford_order_date',
        prattford_order_date_owner = '$prattford_order_date_owner',
        estimated_shipping_date_verify = '$estimated_shipping_date_verify',
        estimated_shipping_date = '$estimated_shipping_date',
        estimated_shipping_date_owner = '$estimated_shipping_date_owner',
        estimated_shipping_schedule_date_verify = '$estimated_shipping_schedule_date_verify',
        estimated_shipping_schedule_date = '$estimated_shipping_schedule_date',
        estimated_shipping_schedule_date_owner = '$estimated_shipping_schedule_date_owner',
        goods_type = '$goods_type',
        goods_type_date = '$goods_type_date',
        goods_type_owner = '$goods_type_owner',
        taiwan_goods_type = '$taiwan_goods_type',
        taiwan_goods_type_date = '$taiwan_goods_type_date',
        taiwan_goods_type_owner = '$taiwan_goods_type_owner',
        shengguanok_status = '$shengguanok_status',
        shengguanok_status_at = '$shengguanok_status_at',
        shengguanok_status_owner = '$shengguanok_status_owner',
        contractno = '$contractno',
        facility_temp_no = '$facility_temp_no',
        renovate_type = '$renovate_type',
        facilityno = '$facilityno',
        custom = '$custom',
        latitude = '$latitude',
        longitude = '$longitude',
        weight = '$weight',
        numberofpassenger = '$numberofpassenger',
        numberofstop = '$numberofstop',
        numberoffloor = '$numberoffloor',
        opentype = '$opentype',
        speed = '$speed',
        site_manager = '$site_manager',
        address = '$address',
        real_address = '$real_address',
        contract_arrival_date = '$contract_arrival_date',
        real_contract_arrival_date = '$real_contract_arrival_date',
        facility_kind = '$facility_kind',
        qc_date = '$qc_date',
        qc_date_owner = '$qc_date_owner',
        end_qc_date = '$end_qc_date',
        end_qc_date_owner = '$end_qc_date_owner',
        official_check_date = '$official_check_date',
        official_check_date_owner = '$official_check_date_owner',
        qc_official_type = '$qc_official_type',
        install_start_date = '$install_start_date',
        install_start_date_owner = '$install_start_date_owner',
        install_end_date = '$install_end_date',
        install_end_date_owner = '$install_end_date_owner',
        tryrun_start_date = '$tryrun_start_date',
        tryrun_start_date_owner = '$tryrun_start_date_owner',
        tryrun_end_date = '$tryrun_end_date',
        tryrun_end_date_owner = '$tryrun_end_date_owner',
        outsourcer_type = '$outsourcer_type',
        install_outsourcer = '$install_outsourcer',
        install_outsourcer_owner = '$install_outsourcer_owner',
        install_outsourcer_date = '$install_outsourcer_date',
        install_outsourcer_date_owner = '$install_outsourcer_date_owner',
        estimate_install_start_date = '$estimate_install_start_date',
        estimate_install_start_date_owner = '$estimate_install_start_date_owner',
        estimate_install_end_date = '$estimate_install_end_date',
        estimate_install_end_date_owner = '$estimate_install_end_date_owner',
        tryrun_outsourcer = '$tryrun_outsourcer',
        tryrun_outsourcer_owner = '$tryrun_outsourcer_owner',
        tryrun_outsourcer_date = '$tryrun_outsourcer_date',
        tryrun_outsourcer_date_owner = '$tryrun_outsourcer_date_owner',
        estimate_tryrun_start_date = '$estimate_tryrun_start_date',
        estimate_tryrun_start_date_owner = '$estimate_tryrun_start_date_owner',
        estimate_tryrun_end_date = '$estimate_tryrun_end_date',
        estimate_tryrun_end_date_owner = '$estimate_tryrun_end_date_owner',
        warehouse_assistant_remark = '$warehouse_assistant_remark',
        official_check_1_file_date = '$official_check_1_file_date',
        official_check_2_file_date = '$official_check_2_file_date',
        official_check_3_file_date = '$official_check_3_file_date',  
        official_check_4_file_date = '$official_check_4_file_date',  
        official_check_5_file_date = '$official_check_5_file_date',  
        official_check_6_file_date = '$official_check_6_file_date',  
        official_check_7_file_date = '$official_check_7_file_date',  
        official_check_8_file_date = '$official_check_8_file_date',
        official_check_9_file_date = '$official_check_9_file_date',
        official_check_1_file_owner = '$official_check_1_file_owner',
        official_check_2_file_owner = '$official_check_2_file_owner',
        official_check_3_file_owner = '$official_check_3_file_owner',
        official_check_4_file_owner = '$official_check_4_file_owner',
        official_check_5_file_owner = '$official_check_5_file_owner',
        official_check_6_file_owner = '$official_check_6_file_owner',
        official_check_7_file_owner = '$official_check_7_file_owner',
        official_check_8_file_owner = '$official_check_8_file_owner',
        official_check_9_file_owner = '$official_check_9_file_owner',
        official_check_file_date = '$official_check_file_date',
        official_check_file_owner = '$official_check_file_owner',
        office_check_file_check_status = '$office_check_file_check_status',
        pinzheng_remark = '$pinzheng_remark',
";


// 附件上傳
$updatesql .= empty($building_heigh_verify_file) ? "" : "building_heigh_verify_file = '$building_heigh_verify_file',";
$updatesql .= empty($site_survey_contact_verify_file) ? "" : "site_survey_contact_verify_file = '$site_survey_contact_verify_file',";
$updatesql .= empty($customer_planning_verify_file) ? "" : "customer_planning_verify_file = '$customer_planning_verify_file',";
$updatesql .= empty($sales_spec_verify_file) ? "" : "sales_spec_verify_file = '$sales_spec_verify_file',";
$updatesql .= empty($customer_color_verify_file) ? "" : "customer_color_verify_file = '$customer_color_verify_file',";
$updatesql .= empty($customer_style_verify_file) ? "" : "customer_style_verify_file = '$customer_style_verify_file',";
$updatesql .= empty($site_survey_contact_form_verify_file) ? "" : "site_survey_contact_form_verify_file = '$site_survey_contact_form_verify_file',";
$updatesql .= empty($official_check_file) ? "" : "official_check_file = '$official_check_file',";
$updatesql .= empty($delivery_date_file) ? "" : "delivery_date_file = '$delivery_date_file',";
$updatesql .= empty($desin_spec_verify_file) ? "" : "desin_spec_verify_file = '$desin_spec_verify_file',";
$updatesql .= empty($desin_planning_verify_file) ? "" : "desin_planning_verify_file = '$desin_planning_verify_file',";
$updatesql .= empty($desin_color_verify_file) ? "" : "desin_color_verify_file = '$desin_color_verify_file',";
$updatesql .= empty($desin_style_verify_file) ? "" : "desin_style_verify_file = '$desin_style_verify_file',";
$updatesql .= empty($desin_documents_verify_file) ? "" : "desin_documents_verify_file = '$desin_documents_verify_file',";
$updatesql .= empty($shengguanok_status_file) ? "" : "shengguanok_status_file = '$shengguanok_status_file',";
$updatesql .= empty($outsourcer_contract_file) ? "" : "outsourcer_contract_file = '$outsourcer_contract_file',";
$updatesql .= empty($building_heigh_verify_file) ? "" : "building_heigh_verify_file = '$building_heigh_verify_file',";
$updatesql .= empty($site_survey_contact_verify_file) ? "" : "site_survey_contact_verify_file = '$site_survey_contact_verify_file',";
$updatesql .= empty($delivery_date_file2) ? "" : "delivery_date_file = '$delivery_date_file2',";
$updatesql .= empty($desin_leader_verify_file) ? "" : "desin_leader_verify_file = '$desin_leader_verify_file',";
$updatesql .= empty($plan_diagram_file) ? "" : "plan_diagram_file = '$plan_diagram_file',";
$updatesql .= empty($completion_acceptance_file) ? "" : "completion_acceptance_file = '$completion_acceptance_file',";

$updatesql .= empty($official_check_1_file) ? "" : "official_check_1_file = '$official_check_1_file',";
$updatesql .= empty($official_check_2_file) ? "" : "official_check_2_file = '$official_check_2_file',";
$updatesql .= empty($official_check_3_file) ? "" : "official_check_3_file = '$official_check_3_file',";
$updatesql .= empty($official_check_4_file) ? "" : "official_check_4_file = '$official_check_4_file',";
$updatesql .= empty($official_check_5_file) ? "" : "official_check_5_file = '$official_check_5_file',";
$updatesql .= empty($official_check_6_file) ? "" : "official_check_6_file = '$official_check_6_file',";
$updatesql .= empty($official_check_7_file) ? "" : "official_check_7_file = '$official_check_7_file',";
$updatesql .= empty($official_check_8_file) ? "" : "official_check_8_file = '$official_check_8_file',";
$updatesql .= empty($official_check_9_file) ? "" : "official_check_9_file = '$official_check_9_file',";

// 備註新增
$updatesql .= "warehouse_remark = '', ";
$updatesql .= "marketing_remark = '', ";
$updatesql .= "desin_leader_remark = '', ";
$updatesql .= "desin_remark = '', ";
$updatesql .= "yewu_remark = '', ";

if (!empty(trim($warehouse_remark))) {
    $updatesql .= "
        all_remark = CONCAT('" . $user_id . accountidToName($user_id) . "_" . $datetime . "<br/>" . $warehouse_remark . "<br/><br/>',IF(all_remark IS NULL,'',all_remark)),
    ";
}
if (!empty(trim($marketing_remark))) {
    $updatesql .= "
        all_remark = CONCAT('" . $user_id . accountidToName($user_id) . "_" . $datetime . "<br/>" . $marketing_remark . "<br/><br/>',IF(all_remark IS NULL,'',all_remark)),
    ";
}
if (!empty(trim($desin_leader_remark))) {
    $updatesql .= "
        all_remark = CONCAT('" . $user_id . accountidToName($user_id) . "_" . $datetime . "<br/>" . $desin_leader_remark . "<br/><br/>',IF(all_remark IS NULL,'',all_remark)),
    ";
}
if (!empty(trim($desin_remark))) {
    $updatesql .= "
        all_remark = CONCAT('" . $user_id . accountidToName($user_id) . "_" . $datetime . "<br/>" . $desin_remark . "<br/><br/>',IF(all_remark IS NULL,'',all_remark)),
    ";
}
if (!empty(trim($yewu_remark))) {
    $updatesql .= "
        all_remark = CONCAT('" . $user_id . accountidToName($user_id) . "_" . $datetime . "<br/>" . $yewu_remark . "<br/><br/>',IF(all_remark IS NULL,'',all_remark)),
    ";
}
if (!empty($plan_diagram_file)) {
    $updatesql .= "
        all_remark = CONCAT('" . $user_id . accountidToName($user_id) . "_" . $datetime . "<br/>上傳了安裝圖附件<br/><br/>',IF(all_remark IS NULL,'',all_remark)),
    ";
}
if (!empty($completion_acceptance_file)) {
    $updatesql .= "
        all_remark = CONCAT('" . $user_id . accountidToName($user_id) . "_" . $datetime . "<br/>上傳了完工驗收單附件<br/><br/>',IF(all_remark IS NULL,'',all_remark)),
    ";
}


$updatesql .= " 
        creater = '$creater', 
        create_at = '$create_at'  
    WHERE 1=1
    AND id = '$id'
";