gary_wms/wms/contract-repair/api/putContractData.php

<?php
require_once("../conn.php");
include_once("./upload_chk.php");
ini_set('date.timezone', 'Asia/Taipei');
// echo json_encode(explode(',', $_POST['deletefiles']));
if (isset($_POST['contracttype']) && $_POST['contracttype'] == 'r' && isset($_POST["id"]) && $_POST['id'] != "") {
    try {
        $create_date = date('Y-m-d H:i:s');
        $repair_no = !empty($_POST['repair_no']) ? $_POST['repair_no'] : null;
        $contractno = !empty($_POST['contractno']) ? $_POST['contractno'] : null;
        $company = !empty($_POST['company']) ? $_POST['company'] : null;
        $taxid   = !empty($_POST['taxid']) ? $_POST['taxid'] : null;
        $facilityno = !empty($_POST['facilityno']) ? $_POST['facilityno'] : null;
        $address = !empty($_POST['address']) ? $_POST['address'] : null;
        $type   = !empty($_POST['type']) ? $_POST['type'] : null;
        $invoice = !empty($_POST['invoice']) ? $_POST['invoice'] : null;
        $repaireid = !empty($_POST['repaireid']) ? $_POST['repaireid'] : null;
        $contract_status = !empty($_POST['contract_status']) ? $_POST['contract_status'] : null;
        // $total_price = !empty($_POST['total_price']) ? $_POST['total_price'] : null;
        $user_id = !empty($_POST['user_id']) ? $_POST['user_id'] : null;

        $fail_arr = [];
        // if (empty($repair_no)) $fail_arr[] = '號為必填';
        // if (empty($contractno)) $fail_arr[] = '合約號為必填';
        if (empty($company)) $fail_arr[] = '客戶名稱為必填';
        if (empty($taxid)) $fail_arr[] = '統一編號為必填';
        if (empty($facilityno)) $fail_arr[] = '電梯號為必填';
        if (empty($address)) $fail_arr[] = '工程地址為必填';
        if (empty($type)) $fail_arr[] = '工程類行為必填';
        if (empty($invoice)) $fail_arr[] = '發票抬頭為必填';
        if (empty($repaireid)) $fail_arr[] = '維修人員為必填';
        if (empty($contract_status)) $fail_arr[] = '工程類別為必填';
        if (count($fail_arr) > 0) {
            header("HTTP/1.1 442 Unprocessable Entity");
            echo json_encode($fail_arr);
            exit();
        }
        $conn->beginTransaction();

        $sql = "UPDATE contract_r_signed_back SET 
        repaireid = :repaireid,facilityno= :facilityno, invoice=:invoice, taxid=:taxid, address=:address,type=:type,contract_status=:contract_status,update_user=:update_user,update_date=:update_date
        WHERE id = :id";

        $stmt = $conn->prepare($sql);
        $stmt->bindParam(':repaireid', $repaireid);
        $stmt->bindParam(':facilityno', $facilityno);
        $stmt->bindParam(':invoice', $invoice);
        $stmt->bindParam(':taxid', $taxid);
        $stmt->bindParam(':address', $address);
        $stmt->bindParam(':type', $type);
        $stmt->bindParam(':contract_status', $contract_status);
        $stmt->bindParam(':update_user', $user_id);
        $stmt->bindParam(':update_date', $create_date);

        $stmt->bindParam(':id', $_POST['id']);
        // echo json_encode($sql);
        // exit;
        $stmt->execute();
        // t8Insert($_POST);
        // header("HTTP/1.1 204 NO Content");

        $conn->commit();
    } catch (PDOException $e) {
        // $conn->rollback();
        header("HTTPP/1.1 500 Internal Server Error");
        die('Error!:' . $e->getMessage());
    }
}

// 塞保養合約進T8的 API function
// function t8Insert($data)
// {
//     require_once('../../contract/connt8.php');
//     $create_date = date('Y-m-dH-i-s');
//     $repair_no = !empty($data['repair_no']) ? $data['repair_no'] : null; // 報價單號
//     $company = !empty($data['company']) ? $data['company'] : null; //立約人
//     $repaireid = !empty($data['repaireid']) ? $data['repaireid'] : null; //維保人員
//     $facilityno = !empty($data['facilityno']) ? $data['facilityno'] : null; // 電梯編號
//     $type = !empty($data['type']) ? $data['type'] : null; //工程進度
//     $sign_date = !empty($data['sign_date']) ? $data['sign_date'] : null; //簽訂時間
//     $invoice = !empty($data['invoice']) ? $data['invoice'] : null; // 發票抬頭
//     $taxid = !empty($data['taxid']) ? $data['taxid'] : null; //統編
//     $address = !empty($data['address']) ? $data['address'] : null; //工程地址
//     $contract_status = !empty($data['contract_status']) ? $data['contract_status'] : null;
//     $user_id = !empty($_data['user_id']) ? $data['user_id'] : null;

//     $sign = str_replace("-", '', $sign_date);
//     $create = str_replace('-', '', $create_date);

//     $sql = "INSERT INTO comBusinessPartner
//     (BizPartnerId,BizPartnerName,BusinessAttr,CountryId,BizToDate,TaxNo,ContactAddress,CreatorId,CreateTime,BizPartnerTypeId)
//     VALUES(:BizPartnerId,:BizPartnerName,1,'TW',99999999,:TaxNo,:ContactAddress,:CreatorId,:CreateTime,'10')";
//     $stmt = $connT8->prepare($sql);
//     $stmt->bindParam(':BizPartnerId', $repair_no); //報價單編號
//     $stmt->bindParam(':BizPartnerName', $company);
//     $stmt->bindParam(':TaxNo', $taxid);
//     $stmt->bindParam(':ContactAddress', $address);
//     $stmt->bindParam(':CreatorId', $user_id);
//     $stmt->bindParam(':CreateTime', $create);
//     $stmt->execute();

//     $sql = "INSERT INTO comCustomer
//     (OrgId,BizPartnerTypeId,CurrId,BizPartnerId,PersonId,CreatorId,IsInUsed,InvoiceAddress,CreateTime)
//     VALUES('1000','10','TWD',:BizPartnerId,:PersonId,:CreatorId,1,:InvoiceAddress,:CreateTime)";
//     $stmt = $connT8->prepare($sql);
//     $stmt->bindParam(':BizPartnerId', $repair_no);
//     $stmt->bindParam(':PersonId', $salesman);
//     $stmt->bindParam(':CreatorId', $user_id);
//     $stmt->bindParam(':InvoiceAddress', $address);
//     $stmt->bindParam(':CreateTime', $create);
//     $stmt->execute();

//     $sql = "INSERT INTO ";

//     $connT8->commit();
// }