add-customer-json

<?php
    include_once "dbconnect.php";


if($_SERVER['REQUEST_METHOD']=='POST'){
    class emp{}


    $user = $_POST['user'];
    $tanggal = $_POST['tanggal'];
    $jam = $_POST['jam'];
    $latitude = $_POST['latitude'];
    $longitude = $_POST['longitude'];


    $image = $_POST['image'];
    $user = $_POST['user'];
    $tanggal = $_POST['tanggal'];
    $jam = $_POST['jam'];
    $latitude = $_POST['latitude'];
    $longitude = $_POST['longitude'];


    $nm_toko = $_POST['nmToko'];
    $tel_toko = $_POST['telToko'];
    $hp_toko = $_POST['hpToko'];
    $fax_toko = $_POST['faxToko'];
    $alm_toko = $_POST['almToko'];
    $kota_toko = $_POST['kotaToko'];
    $tipe_toko = $_POST['tipeToko'];

    $ktp_cust = $_POST['ktpCust'];
    $nm_cust = $_POST['nmCust'];
    $alm_cust = $_POST['almCust'];
    $kota_cust = $_POST['kotaCust'];

    $npwp_cust = $_POST['npwpCust'];
    $alm_npwp_cust = $_POST['almNpwp'];
    $nama_npwp_cust = $_POST['nmNpwp'];
    $nppkp_cust = $_POST['nppkp'];

    $payment_cust = $_POST['paymentCust'];
    $limit_cust = $_POST['limitToko'];
    $top_cust = $_POST['topToko'];

    $foto_cust = $_POST['fotoToko'];
    $foto_ktp_cust = $_POST['fotoKtp'];
    $foto_signature_cust = $_POST['fotoSignature'];
    $status="pending";


        $random = random_word(20);

        $pathToko = "upload/toko/".$random.".png";
        $pathKTP = "upload/ktp/".$random.".png";
        $pathsignature = "upload/signature/".$random.".png";

        $actualpath = $random.".png";

        $node = mysqli_query($con, "SELECT Node_ID from tbl_user_pass where User_LoginName='$user');

        $locationToko = mysqli_query($con, "SELECT po.postal_name, co.country_name FROM tbl_postal po
                                            LEFT JOIN tbl_city ci ON ci.postal_id=po.postal_id
                                            LEFT JOIN tbl_country co ON co.country_id=po.country_id
                                            WHERE ci.city_name='$kota_toko'");

        $locationOwner = mysqli_query($con, "SELECT po.postal_name, co.country_name FROM tbl_postal po
                                            LEFT JOIN tbl_city ci ON ci.postal_id=po.postal_id
                                            LEFT JOIN tbl_country co ON co.country_id=po.country_id
                                            WHERE ci.city_name='$kota_cust'");

        $hasiltoko=mysqli_fetch_array($locationToko);
        $hasilowner=mysqli_fetch_array($locationOwner);
        $hasilnode=mysqli_fetch_array($node);

        $insertCustomer = mysqli_query($con, "INSERT INTO tbl_customer_pending (cust_company,cust_name,cust_address1,cust_city,cust_postal,cust_country
        cust_phone,cust_fax,cust_mobile,cust_id_number,cust_id_address1,cust_id_city,cust_id_postal,cust_id_country,cust_NPWP,cust_NPWP_Address1
        cust_NPWP_Name,cust_NPPKP,cust_payment,cust_limit,cust_TOP,cust_Type,cust_since,cust_salesID,Node_ID,cust_latitude,cust_longitude,cust_status,
        cust_pic,cust_id_pic,cust_signature) VALUES     ('$nm_toko','$nm_cust','$alm_toko','$kota_toko','$hasiltoko['postal_name']','$hasiltoko['country_name']','$tel_toko','$fax_toko','$hp_toko',
        '$ktp_cust','$alm_cust','$kota_cust','$hasilowner['postal_name']','$hasilowner['country_name']','$npwp_cust','$alm_npwp_cust','$nm_npwp_cust',
        '$nppkp_npwp','$payment_cust','$limit_cust','$top_cust','$tipe_toko','$tanggal','$user','$hasilnode['Node_ID']','$latitude','$longitude','$status'
        '$pathToko','$pathKTP','$pathSignature')");

        if ($insertCustomer){
            file_put_contents($pathToko,base64_decode($foto_cust));
            file_put_contents($pathKTP,base64_decode($foto_ktp_cust));
            file_put_contents($pathSignature,base64_decode($foto_signature_cust));

            $response = new emp();
            $response->success = 1;
            $response->message = "Berhasil Menambah Customer";
            die(json_encode($response));
        } else{
            $response = new emp();
            $response->success = 0;
            $response->message = "Terjadi Kesalahan Pada Server";
            die(json_encode($response));
        }
    }

    // fungsi random string pada gambar untuk menghindari nama file yang sama
        function random_word($id = 20){
        $pool = '1234567890abcdefghijkmnpqrstuvwxyz';

        $word = '';
        for ($i = 0; $i < $id; $i++){
            $word .= substr($pool, mt_rand(0, strlen($pool) -1), 1);
        }
        return $word;
    }
    mysqli_close($con);

?>