$R_Center = "SIIT"; $R_Center_code = "SIIT"; $veh_use = '61'; $veh_reg_no = strtoupper(trim(preg_replace('/\s+/','',$dataArry[$i]["vehicle"]["vehRegNo"]))); $reg_state = $dataArry[$i]["vehicle"]["regState"]; $eng_numb = $dataArry[$i]["vehicle"]["engNumb"]; $chasis_numb = $dataArry[$i]["vehicle"]["chasisNumb"]; $veh_make = $dataArry[$i]["vehicle"]["vehMake"]; $veh_type = $dataArry[$i]["vehicle"]["vehType"]; $veh_color = $dataArry[$i]["vehicle"]["vehColor"]; $net_wght = $dataArry[$i]["vehicle"]["netWeight"]; $veh_use = $veh_use;//$dataArry[$i]["vehicle"]["vehUse"]; $vRoute = $dataArry[$i]["vehicle"]["vRoute"]; $vPark = $dataArry[$i]["vehicle"]["vPark"]; $roadWTH = $dataArry[$i]["vehicle"]["roadWTH"]; $qr_code_url = $dataArry[$i]["vehicle"]["qr_code_url"]; $vOWN = explode(" ",$dataArry["owner"]["name"]); $s_name = $vOWN[0]; $f_name = $vOWN[1]; if(count($vOWN) > 2){ $m_name = $vOWN[2]; }else{ $m_name = ''; } $OwnerReg = $gender = $dataArry["owner"]["OwnerReg"]; $gender = $dataArry["owner"]["gender"]; $addr = $dataArry["owner"]["address"]; $e_mail = $dataArry["owner"]["e_mail"]; $phone = $dataArry["owner"]["phoneNumb"]; $m_phone = $dataArry["owner"]["phoneNumb"]; $pic_image = $dataArry["owner"]["passportImage"]; $taxID = date('ymdhis'); //'240915020351'; $resCheck = @mysql_query("SELECT o.reg_no, o.taxID, v.reg_no,v.veh_reg_no,v.M_veh_reg_no, v.hack_pmt_no FROM vehicle_owner_tab_siit o, vehicle_reg_tab_siit v WHERE o.taxID = v.taxID AND v.old_veh_reg_no = '$veh_reg_no'"); if(mysql_affected_rows() > 0){ list($ownerRegNo, $taxID, $reg_no, $RLnwVHgen, $nwVHgen, $vehHACPMT) = @mysql_fetch_array($resCheck); $opSt = 'UP'; //update Vehicle details and return its Tag @mysql_query("UPDATE `vehicle_reg_tab_siit` SET `veh_color` = '$veh_color', `route_code` = '$vRoute', `dateAllc` = now(), `park_code` = '$vPark', `rw_code` = '$roadWTH', `roadWTH` = '$roadWTH' WHERE `old_veh_reg_no` = '$veh_reg_no'"); $TagNumber = $vehHACPMT; }else{ $opSt = 'NW'; $ress = @mysql_query("SELECT MAX(id) FROM `vehicle_reg_tab_siit`"); list($gSN) = @mysql_fetch_array($ress); $reg_no = 'V'.$R_Center_code.'VH'; if($gSN == ''){ $addRg = '00001'; }else{ $addRg = '00000'.($gSN + 1); } $reg_no .= substr($addRg, -5); //generate new Veh_registration Number LA99999MT ( 00001 to 99999) $getVTP = @mysql_query("SELECT `item_xdesc` FROM `code_param_desc` WHERE `tab_index` = '61' AND `item_code` = '$veh_use'"); list($veuseCD) = @mysql_fetch_array($getVTP); $CHKmV = @mysql_query("SELECT MAX(other_item) FROM `code_param_desc` WHERE `tab_index` = '61' AND `item_code` = '$veh_use'"); list($M_veh_reg_no) = @mysql_fetch_array($CHKmV); if($M_veh_reg_no == ''){ $nwVHgen = '00001'; }else{ $nwVHgen = '0000'.($M_veh_reg_no+1); } $nwVHgen = substr($nwVHgen, -5); $RLnwVHgen = 'LA'.$nwVHgen.$veuseCD; $vehHACPMT = $veuseCD.$nwVHgen.'LA'; $hackExpry = (date('Y')+1).'-'.date('m').'-'.date('d'); //vehicle data $vHCPMT = $vehHACPMT; //check if veh_reg_no exist on the system @mysql_query("SELECT * FROM `vehicle_reg_tab_siit` WHERE `veh_reg_no` = '$RLnwVHgen'"); if(mysql_affected_rows() > 0){ //re-process reg number again //$reg_no = 'V'.$R_Center_code.'-'.$vHCPMT; $ress = @mysql_query("SELECT MAX(id) FROM `vehicle_reg_tab_siit`"); list($gSN) = @mysql_fetch_array($ress); $reg_no = 'V'.$R_Center_code.'VH'; if($gSN == ''){ $addRg = '00001'; }else{ $addRg = '00000'.($gSN + 1); } $reg_no .= substr($addRg, -5); //generate new Veh_registration Number LA99999MT ( 00001 to 99999) $getVTP = @mysql_query("SELECT `item_xdesc` FROM `code_param_desc` WHERE `tab_index` = '61' AND `item_code` = '$veh_use'"); list($veuseCD) = @mysql_fetch_array($getVTP); $CHKmV = @mysql_query("SELECT MAX(other_item) FROM `code_param_desc` WHERE `tab_index` = '61' AND `item_code` = '$veh_use'"); list($M_veh_reg_no) = @mysql_fetch_array($CHKmV); if($M_veh_reg_no == ''){ $nwVHgen = '00001'; }else{ $nwVHgen = '0000'.($M_veh_reg_no+1); } $nwVHgen = substr($nwVHgen, -5); $RLnwVHgen = 'LA'.$nwVHgen.$veuseCD; $vehHACPMT = $veuseCD.$nwVHgen.'LA'; $hackExpry = (date('Y')+1).'-'.date('m').'-'.date('d'); //vehicle data $vHCPMT = $vehHACPMT; } } if($dataArry["owner"]["name"] != ''){ if($dataArry["owner"]["OwnerReg"] != ''){ //update owner record $resGetOwner = @mysql_query("SELECT o.reg_no, o.taxID FROM vehicle_owner_tab_siit o WHERE o.reg_no = '".$dataArry["owner"]["OwnerReg"]."'"); if(mysql_affected_rows() > 0){ list($reg_nod, $taxID) = @mysql_fetch_array($resGetOwner); $reg_noExist = $reg_nod; $opOWN = 'UP'; $ID = $dataArry["owner"]["OwnerReg"]; $OwnerNumber = $ID; /** // update Owner vehicle details if($dataArry["owner"]['passportImage'] != ''){ $imgCnt = $init->save_base64_image($dataArry["owner"]['passportImage'], $reg_nod, "../../public_html/OwnerPhoto_SIIT/" ); if($imgCnt != ''){ $pic_image = str_replace('../','',$imgCnt); } //$fnamR = '../OwnerPhoto_SIIT/'.$imgCnt; } $adSql = ''; if($imgCnt != ''){ $pic_image = str_replace('../','',$fnamR);//passport; $adSql .= ",`pic_image` = '$pic_image'"; } **/ $sql_h = "INSERT INTO vehicle_owner_tab_siit_history (`reg_no`, `taxID`, `s_name`, `f_name`, `m_name`, `gender`, `addr`, `e_mail`, `phone`, `m_phone`, `pic_image`, `finget_image`)SELECT `reg_no`, `taxID`, `s_name`, `f_name`, `m_name`, `gender`, `addr`, `e_mail`, `phone`, `m_phone`, `pic_image`, `finget_image` FROM vehicle_owner_tab_siit WHERE `reg_no` = '$ID'"; @mysql_query($sql_h); $rid = mysql_insert_id(); @mysql_query("UPDATE `vehicle_owner_tab_siit_history` SET `adminID` = '".$_SESSION['reg_ID']."', `date_chng` = now(), `status` = '1' WHERE id = '$rid'"); //@mysql_query("UPDATE `vehicle_owner_tab_siit` SET `s_name` = '$s_name', `f_name` = '$f_name', `m_name` = '$m_name', `gender` = '$gender', `addr` = '$addr', `e_mail` = '$e_mail', `phone` = '$phone', `adminID` = 'SIIT', `m_phone` = '$m_phone'".$adSql." WHERE `reg_no` = '$ID'"); //$OwnerNumber = $OwnerReg; }else{ $opOWN = 'NW'; //New Owner ID //$taxID = date('ymdhis'); //'240915020351'; } }else{ $opOWN = 'NW'; //New Owner ID //$taxID = date('ymdhis'); //'240915020351'; } }else{ $opOWN = 'NW'; //New Owner ID //$taxID = date('ymdhis'); //'240915020351'; } //creating vehicle accreditation details if($opSt == 'NW'){ //".$hyear.'-'.$hmonth.'-'.$hday." $veh_reg_no = strtoupper(trim(preg_replace('/\s+/','',$veh_reg_no))); $sql = "INSERT INTO `vehicle_reg_tab_siit` ( `reg_no`, `veh_reg_no`, `M_veh_reg_no`, `old_veh_reg_no`, `reg_state`, `eng_numb`, `chasis_numb`, `veh_make`, `veh_type`, `veh_color`, `net_wght`, `veh_use`, `hack_pmt_no`, `hack_pmt_exp_date`, `route_code`, `park_code`, `datereg`, `reg_center`, `reg_center_code`, `taxID`, `roadWTH`, `dateAllc`, `adminID` ) VALUES ( '$reg_no', '$RLnwVHgen', '$nwVHgen', '$veh_reg_no', '$reg_state', '$eng_numb', '$chasis_numb', '$veh_make', '$veh_type', '$veh_color', '$net_wght', '$veh_use', '$vehHACPMT', '$hackExpry', '$vRoute', '$vPark', now(), '$R_Center', '$R_Center_code', '$taxID', '$roadWTH', now(), 'SIIT' )"; //echo $sql; @mysql_query($sql); if(mysql_affected_rows() > 0){ @mysql_query("UPDATE code_param_desc SET other_item = '$nwVHgen' WHERE `tab_index` = '61' AND `item_code` = '$veh_use'"); $veh_reg_no = $RLnwVHgen; //vehicle owner data //exit(); $ress2 = @mysql_query("SELECT MAX(id) FROM `vehicle_owner_tab_siit`"); list($pmnID) = @mysql_fetch_array($ress2); $sedNo = '0000'.($pmnID + 1); $tgSeed = substr($sedNo, -5); $tag_number = $vehHACPMT;//'V'.$R_Center_code.'-'.$tgSeed;//$vHCPMT; $bodyTag = $tag_number; $sqlQ = "INSERT INTO `veh_bdy_tag_siit` (`veh_reg_no`, `hack_pmt_no`, `bodyTag`, `pyID`,`date_issued`,`qr_code_url`) VALUES ('$veh_reg_no', '$vHCPMT', '$bodyTag','$pmnID',now(),'$qr_code_url')"; //echo $sqlQ; @mysql_query($sqlQ); if(mysql_affected_rows() > 0){ @mysql_query("UPDATE `route_master_tab` SET `tot_no_allocate` = `tot_no_allocate` + 1 WHERE id = '$vRoute'"); //set Tag Number $TagNumber = $bodyTag; }else{ //@mysql_query("DELETE FROM `paymnt_master_tab` WHERE `id` = '$pmnID'"); @mysql_query("DELETE FROM `vehicle_reg_tab_siit` WHERE `reg_no` = '$reg_no'"); @mysql_query("UPDATE code_param_desc SET other_item = (other_item - 1) WHERE `tab_index` = '61' AND `item_code` = '$veh_use'"); $myObjPack->$i = array( $myObj->response_code = "00", $myObj->response_message= 'Error processing Vehicle Accreditation' ); } }else{ //update count problem $nwVHgen = $nwVHgen+1; @mysql_query("UPDATE code_param_desc SET other_item = '$nwVHgen' WHERE `tab_index` = '61' AND `item_code` = '$veh_use'"); $myObjPack->$i = array( $myObj->response_code = "00", $myObj->response_message= 'Error creating Vehicle Accreditation' ); } } //creating new vehicle Owner details if($opOWN == 'NW'){ //create New Owner $ress2 = @mysql_query("SELECT MAX(id) FROM `vehicle_owner_tab_siit`"); list($gSN2) = @mysql_fetch_array($ress2); $reg_noW = 'V'.$R_Center_code.'VHWSIT'; if($gSN2 == ''){ $addRg2 = '00001'; }else{ $addRg2 = '00000'.($gSN2 + 1); } $reg_noW .= substr($addRg2, -5); /** $pic_image = ''; if($dataArry["owner"]['passportImage'] != ''){ $imgCnt = $init->save_base64_image($dataArry["owner"]['passportImage'], $reg_no, "../../public_html/OwnerPhoto_SIIT/" ); if($imgCnt != ''){ $pic_image = str_replace('../','',$imgCnt); } } **/ if($reg_noExist == ''){ if($pic_image != ''){ $addUPD = ", `pic_image` = '$pic_image'"; } @mysql_query( "INSERT INTO `vehicle_owner_tab_siit` ( `reg_no`, `s_name`, `f_name`, `m_name`, `gender`, `addr`, `e_mail`, `phone`, `m_phone`, `pic_image`, `taxID`, `adminID` ) VALUES ( '$reg_noW', '$s_name', '$f_name', '$m_name', '$gender', '$addr', '$e_mail', '$phone', '$m_phone', '$pic_image', '$taxID', 'SIIT' ) ON DUPLICATE KEY UPDATE `s_name` = '$s_name', `f_name` = '$f_name', `m_name` = '$m_name', `gender` = '$gender', `addr` = '$addr', `e_mail` = '$e_mail', `phone` = '$phone', `adminID` = 'SIIT', `m_phone` = '$m_phone'".$addUPD." " ); $pmnID = mysql_insert_id(); $OwnerNumber = $reg_noW; }else{ $resOwCH = @mysql_query("SELECT `reg_no` FROM `vehicle_owner_tab_siit` WHERE `reg_no` = '$OwnerReg'"); if(mysql_affected_rows() > 0){ //Set Owner registration Number $OwnerNumber = $OwnerReg; @mysql_query(" INSERT INTO `vehicle_owner_tab_siit` ( `reg_no`, `s_name`, `f_name`, `m_name`, `gender`, `addr`, `e_mail`, `phone`, `m_phone`, `pic_image`, `taxID`, `adminID` ) VALUES ( '$OwnerReg', '$s_name', '$f_name', '$m_name', '$gender', '$addr', '$e_mail', '$phone', '$m_phone', '$pic_image', '$taxID', 'SIIT' ) ON DUPLICATE KEY UPDATE `s_name` = '$s_name', `f_name` = '$f_name', `m_name` = '$m_name', `gender` = '$gender', `addr` = '$addr', `e_mail` = '$e_mail', `phone` = '$phone', `adminID` = 'SIIT', `m_phone` = '$m_phone'".$addUPD." " ); $pmnID = mysql_insert_id(); if(mysql_affected_rows() > 0){ if($m_phone != '' || $phone != ''){ if($m_phone == ''){ $m_phone = $phone; } //Send Accreditation SMS $mmssg = "Your vehicle regNum ".$veh_reg_no." has been duly accredited as commercial persenger carrying vehicle by Lagos State PTCS"; $init->sendVehicleAccred_SMS($mmssg,$m_phone,$veh_reg_no,$paymentRefNo); } } } } } //Rider information processing if($dataArry["Rider"]["PhoneNumber"] != '' ){ //&& $dataArry["Rider"]["NationalDriverLicense"] != '' $lasdri_code = $dataArry["Rider"]["LASDRICardNumber"]; //$l_licence = $dataArry["Rider"]["NationalDriverLicense"]; $l_licence = $dataArry["Rider"]["NationalDriverLicense"]==''?$dataArry["Rider"]["PhoneNumber"]:$dataArry["Rider"]["NationalDriverLicense"]; $gender = $dataArry["Rider"]["gender"]; $m_status = $dataArry["Rider"]["MaritalStatus"]; $addr = $dataArry["Rider"]["Address"]; $m_phone = $dataArry["Rider"]["PhoneNumber"]; $pic_image = $dataArry["Rider"]["PhotoPassport"]; $Name = $dataArry["Rider"]["RiderName"]; $NameDsip = explode(" ",$Name); $s_name = $NameDsip[0]; $NameDsip = $f_name [0]; if(count($NameDsip) >= 2){ $m_name = $NameDsip[2]; } $reg_no = ''; $getDRV = @mysql_query("SELECT `reg_no`,`taxID` FROM `veh_driver_tab_siit` WHERE `l_number` = '$l_licence'"); if(mysql_affected_rows() > 0){ list($reg_no, $taxID) = @mysql_fetch_array($getDRV); }else{ $ress = @mysql_query("SELECT MAX(id) FROM `veh_driver_tab_siit`"); list($gSN) = @mysql_fetch_array($ress); $reg_no = 'V'.$R_Center_code.'D'; if($gSN == ''){ $addRg = '00001'; }else{ $addRg = '00000'.($gSN + 1); } $reg_no .= substr($addRg, -5); $taxID = 'D-'.date('ymhis'); } /** $pic_image = ''; if($dataArry["Rider"]["PhotoPassport"] != ''){ $imgCnt = $init->save_base64_image($dataArry["Rider"]["PhotoPassport"], $reg_no, "../../public_html/DriverPhoto_SIIT/" ); if($imgCnt != ''){ $pic_image = str_replace('../','',$imgCnt); } } **/ //Driver data $sql = "INSERT INTO `veh_driver_tab_siit` ( `reg_no`, `surname`, `f_name`, `m_name`, `address`, `phone_no`, `marital_status`, `gender`, `l_number`, `lasdri_code`, `pic_image`, `reg_center`, `reg_center_code`, `datereg`, `taxID`, `veh_cate`, `adminID` ) VALUES ( '$reg_no', '$s_name', '$f_name', '$m_name', '$addr', '$m_phone', '$m_status', '$gender', '$l_licence', '$lasdri_code', '$pic_image', '$R_Center', '$R_Center_code', now(), '$taxID', '$veh_cate', 'SIIT' ) ON DUPLICATE KEY UPDATE `reg_no` = '$reg_no', `surname` = '$s_name', `f_name` = '$f_name', `m_name` = '$m_name', `address` = '$addr', `phone_no` = '$m_phone', `marital_status` = '$m_status', `gender` = '$gender', `l_number` = '$l_licence', `lasdri_code` = '$lasdri_code', `reg_center` = '$R_Center', `reg_center_code` = '$R_Center_code', `datereg` = now(), `taxID` = '$taxID', `veh_cate` = '$veh_cate', `adminID` = 'SIIT' "; //echo $sql; @mysql_query($sql); if(mysql_affected_rows() > 0){ $RiderNumber = $reg_no; //Pair to a vehicle if($veh_reg_no != ''){ @mysql_query("UPDATE `vehicle_reg_tab_siit` SET `rider_reg_no` WHERE `old_veh_reg_no` = ''"); } } if($reg_no != ''){ $RiderNumber = $reg_no; }else{ $myObjPack->$i = array( $myObj->response_code = "00", $myObj->response_message= "Error processing Rider data" ); } } if($TagNumber != '' || $OwnerNumber != '' || $RiderNumber != ''){ $myObjPack->$i = array( $myObj->response_code = "200", $myObj->response_message= "Success", $myObj->data = array ( "TagNumber" => $TagNumber, "OwnerNumber" => $OwnerNumber, "RiderNumber" => $RiderNumber ) ); }else{ $myObjPack->$i = array( $myObj->response_code = "00", $myObj->response_message= "Error processing Data Sent" ); } }else{ $error = ' '; if($dataArry[$i]["vehicle"]["vehRegNo"] == ''){ $error .='Missing Vehicle Registration Number, '; } /* if($dataArry[$i]["vehicle"]["engNumb"] == ''){ $error.='Missing Vehicle Engine Number, '; } */ if($dataArry[$i]["vehicle"]["chasisNumb"] == ''){ $error.='Missing Vehicle Chassis Number, '; } if($dataArry[$i]["vehicle"]["vehMake"] == ''){ $error.='Missing Vehicle Make, '; } if($dataArry[$i]["vehicle"]["vehType"] == ''){ $error.='Missing Vehicle Type, '; } if($dataArry[$i]["vehicle"]["vehColor"] == ''){ $error.='Missing Vehicle Colour, '; } if($dataArry[$i]["vehicle"]["vRoute"] == ''){ $error.='Missing Route Assigned, '; } if($dataArry[$i]["vehicle"]["vPark"] == ''){ $error.='Missing Park Assigned'; } if($dataArry["Rider"]["PhoneNumber"] == ''){ $error.='Missing Riders Phone Number'; } /** if($dataArry["Rider"]["NationalDriverLicense"] == ''){ $error.='Missing Riders Driver License'; } **/ $myObjPack->$i = array( $myObj->response_code = "00", $myObj->response_message= $error ); } } } }else{ $myObj->response_code = "00"; $myObj->response_message= "Invalid AUthorization"; $myJSON = json_encode($myObj); echo $myJSON; exit; } $myJSON = json_encode($myObjPack); echo $myJSON;