}
$DataCSVFile = "wecaredata3.csv";
$dataDir = "/home/ubuntu/data/doc3/";
if (!validateDirStr($dataDir)) {
die("\n invalid File Structure\n");
}
$config['host'] = "localhost";
$config['user'] = "******";
$config['password'] = "******";
$config['database'] = "bluenet_v3";
$db_handle = mysqli_connect($config['host'], $config['user'], $config['password'], $config['database']);
if (($handle = fopen($DataCSVFile, "r")) !== FALSE) {
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
$lName = $data[8];
$lMobile = $data[9];
$lAddress = $data[4];
$localId = $data[0];
$wName = $data[1];
$wMobile = $data[2];
$wAddress = $data[7];
$service = $data[6];
$emergency_no = $data[3];
$native_add = $data[5];
$refId = createCustomer($db_handle, $lName, $lMobile, $lAddress);
$outArray = UploadDocs($dataDir, $localId);
$wId = createCustomerWorker($db_handle, $wName, $wMobile, $wAddress, $outArray['photo'], $refId, $localId, $service, $outArray['pv'], $outArray['adhar_card'], $outArray['voter_card'], $outArray['driving_license'], $outArray['pan_card'], $emergency_no, $native_add);
echo $wId . ",";
}
fclose($handle);
}
mysqli_close($db_handle);
$sql = "INSERT INTO `bluenet_v3`.`workers` (`id`, `ref_id`, `user_id`, `status`, `emergency_no`, `native_place`,\n\t\t\t\t\t\t\t\t`native_add`, `dob`, `education`, `experience`, `gender`, `remark`, `salary`, `local_id`)\n\t\t\t\tVALUES (NULL,\n\t\t\t\t\t'" . $refId . "',\n\t\t\t\t\t'" . $uwId . "',\n\t\t\t\t\t 'recruited',\n\t\t\t\t\t '" . $emergency_no . "',\n\t\t\t\t\t '',\n\t\t\t\t\t '" . $native_add . "',\n\t\t\t\t\t\t'',\n\t\t\t\t\t\t '',\n\t\t\t\t\t\t '',\n\t\t\t\t\t\t '',\n\t\t\t\t\t\t '',\n\t\t\t\t\t\t\t'',\n\t\t\t\t\t\t\t '" . $localId . "');";
mysqli_query($db_handle, $sql);
$wId = mysqli_insert_id($db_handle);
//echo $wId. "\n";
if ($wId == 0 || $wId == null) {
echo " Error: " . mysqli_error($db_handle);
die;
}
$sId = array('maid' => 1, 'cook' => 2, 'car cleaner' => 15);
//5. adding worker service
$sql = "INSERT INTO `bluenet_v3`.`service_worker_mappings`\n\t\t\t\t(`id`, `worker_id`, `service_id`)\n\t\t\t\t\tVALUES ('',\n\t\t\t\t\t'" . $wId . "',\n\t\t\t\t\t '" . $sId[$service] . "'\n\t\t\t\t\t );";
mysqli_query($db_handle, $sql);
//6. adding worker society mapping
$sql = "INSERT INTO `bluenet_v3`.`society_worker_mapping`\n\t\t\t\t(`worker_id`, `society_id`)\n\t\t\t\t\tVALUES (\n\t\t\t\t\t'" . $wId . "',\n\t\t\t\t\t '" . $society . "'\n\t\t\t\t\t );";
mysqli_query($db_handle, $sql);
return $uwId;
}
function createDocUid($dbHandle, $uwId, $pvUid, $adharCardUid, $voterCardUid, $drivingLicenseUid, $panCardUid)
{
$sql = "INSERT INTO `bluenet_v3`.`user_documents_uid` (`id`, `user_id`, `pv_uid`, `adhar_card_uid`, `voter_id_uid`, `driving_license_uid`, `pan_card_uid`)\n\t\t\t\tVALUES (NULL,\n\t\t\t\t\t'" . $uwId . "',\n\t\t\t\t\t'" . $pvUid . "',\n\t\t\t\t\t '" . $adharCardUid . "',\n\t\t\t\t\t '" . $voterCardUid . "',\n\t\t\t\t\t '" . $drivingLicenseUid . "',\n\t\t\t\t\t\t'" . $panCardUid . "');";
return mysqli_query($dbHandle, $sql);
}
$refId = createCustomer($db_handle, $input->root->resident_name, $input->root->resident_mobile, $input->root->resident_address, $route[2]);
if ($refId != 0) {
$wId = createCustomerWorker($db_handle, $input->root->worker_name, $input->root->worker_mobile, $input->root->worker_address, $input->root->worker_photo, $refId, $input->root->worker_localId, $input->root->worker_service, $input->root->worker_pv, $input->root->worker_ac, $input->root->worker_vc, $input->root->worker_dl, $input->root->worker_pc, $input->root->worker_emergency_no, $input->root->worker_native_add, $route[2]);
createDocUid($db_handle, $wId, $input->root->worker_pv_uid, $input->root->worker_ac_uid, $input->root->worker_vc_uid, $input->root->worker_dl_uid, $input->root->worker_pc_uid);
//echo $refId." ".$wId.",";
$input->root->resident_id = $refId;
$input->root->worker_id = $wId;
}
print json_encode($input);
