alert('Data not sent successfuly: MISSING DATA');"; // //header('HTTP/1.1 400 Bad Request'); // exit(); echo json_encode(array("success"=>false,"message"=>"Data not sent successfuly: MISSING DATA"),JSON_PRETTY_PRINT); exit(); } //20180131 - Reference number added to investment concept for output on the pdf -CL // $pdo = $DBH->query("SELECT IF(MAX(sbic_reference_number) IS NULL,0,MAX(sbic_reference_number))+1 as sbic_reference_number FROM sb_kruger_sell_calc"); // while ($row = $pdo->fetch()) // { // $intReferenceNumber = $row['sbic_reference_number']; // $strReferenceNumber = "KRGSELL".str_pad($intReferenceNumber, 6, "0",STR_PAD_LEFT); // } if($calc_collect_location == "BRINKS Bedfordview") { //20180131 - Reference number added to investment concept for output on the pdf -CL $pdo = $DBH->query("SELECT IF(MAX(sbic_reference_bed_number) IS NULL,0,MAX(sbic_reference_bed_number))+1 as sbic_reference_bed_number FROM sb_kruger_sell_calc"); while ($row = $pdo->fetch()) { $intBedReferenceNumber = $row['sbic_reference_bed_number']; $strReferenceNumber = "SABSRBDV".str_pad($intBedReferenceNumber, 5, "0",STR_PAD_LEFT); } $intCapReferenceNumber = 0; }else{ //20180131 - Reference number added to investment concept for output on the pdf -CL $pdo = $DBH->query("SELECT IF(MAX(sbic_reference_cpt_number) IS NULL,0,MAX(sbic_reference_cpt_number))+1 as sbic_reference_cpt_number FROM sb_kruger_sell_calc"); while ($row = $pdo->fetch()) { $intCapReferenceNumber = $row['sbic_reference_cpt_number']; $strReferenceNumber = "SABSRCPT".str_pad($intCapReferenceNumber, 5, "0",STR_PAD_LEFT); } $intBedReferenceNumber = 0; } if($strReferenceNumber != null) { //20171108 - Update Investment Calculator to save name as first and last name -CL //20190523 - Added New Fields on Save function - Gael $pdo = $DBH->prepare("INSERT INTO sb_kruger_sell_calc ( sbic_first_name , sbic_last_name , sbic_mail , sbic_id_number , sbic_passport_number , sbic_telephone , sbic_mobile , sbic_kruger_quantity , sbic_kruger_cost_total , sbic_reference_bed_number , sbic_reference_cpt_number , sbic_reference_string , sbic_collect_location , sbic_notes , sbic_kruger_quantity_half , sbic_kruger_quantity_quarter , sbic_kruger_quantity_tenth , sbic_current_sell_price , sbic_total_coin_weight , sbic_total_sell_price , sbic_address_line_one , sbic_address_line_two , sbic_city , sbic_postal_code ) VALUES ( :sbic_first_name , :sbic_last_name , :sbic_mail , :sbic_id_number , :sbic_passport_number , :sbic_telephone , :sbic_mobile , :sbic_kruger_quantity , :sbic_kruger_cost_total , :sbic_reference_bed_number , :sbic_reference_cpt_number , :sbic_reference_string , :sbic_collect_location , :sbic_notes , :sbic_kruger_quantity_half , :sbic_kruger_quantity_quarter , :sbic_kruger_quantity_tenth , :sbic_current_sell_price , :sbic_total_coin_weight , :sbic_total_sell_price , :sbic_address_line_one , :sbic_address_line_two , :sbic_city , :sbic_postal_code ) "); $pdo->execute(array( ":sbic_first_name" => $calc_first_name , ":sbic_last_name" => $calc_last_name , ":sbic_mail" => $calc_email , ":sbic_id_number" => $idNumber , ":sbic_passport_number" => $passportNumber , ":sbic_telephone" => $calc_telephone , ":sbic_mobile" => $calc_mobile , ":sbic_kruger_quantity" => $calc_kruger_quantity , ":sbic_kruger_cost_total" => $calc_kruger_cost_total , ":sbic_reference_bed_number" => $intBedReferenceNumber , ":sbic_reference_cpt_number" => $intCapReferenceNumber , ":sbic_reference_string" => $strReferenceNumber , ":sbic_collect_location" => $calc_collect_location , ":sbic_notes" => $strAdditionalNotes , ":sbic_kruger_quantity_half" => $dblKrugerrandQuantityTwo , ":sbic_kruger_quantity_quarter" => $dblKrugerrandQuantityThree , ":sbic_kruger_quantity_tenth" => $dblKrugerrandQuantityFour , ":sbic_current_sell_price" => $dblCurrentSellPrice , ":sbic_total_coin_weight" => $dblTotalCoinWeight , ":sbic_total_sell_price" => $dblTotalSellPrice , ":sbic_address_line_one" => $strAddressLineOne , ":sbic_address_line_two" => $strAddressLineTwo , ":sbic_city" => $strCity , ":sbic_postal_code" => $strPostalCode )); $affected_rows = $pdo->rowCount(); if($affected_rows >= 1) { echo json_encode(array("success"=>true,"strReferenceNumber"=>$strReferenceNumber),JSON_PRETTY_PRINT); }else{ //echo ""; echo json_encode(array("success"=>false,"message"=>"Data not successfully Inserted."),JSON_PRETTY_PRINT); } $DBH = null; } else { //echo ""; echo json_encode(array("success"=>false,"message"=>"Data not successfully Inserted."),JSON_PRETTY_PRINT); } }catch(PDOException $e) { echo $e->getMessage(); } ?>