function addData()
{
$gmoId = "";
$name = "";
$designation = null;
$address1 = null;
$address2 = null;
$phone1 = null;
$email = "";
$phone2 = null;
$mobile = null;
$user = '******';
$pass = '******';
$flag1 = null;
if (isset($_GET['add'])) {
$name = $_GET['name'];
$designation = $_GET['designation'];
$address1 = $_GET['address1'];
$address2 = $_GET['address2'];
$email = $_GET['email'];
$phone1 = $_GET['phonenumber1'];
$phone2 = $_GET['phonenumber2'];
$mobile = $_GET['mobilenumber'];
$user = $_GET['username'];
$pass = $_GET['password'];
$resultdist = mysql_query("select districtid from district where name='" . $_GET['district'] . "' ") or die(mysql_error());
$rowdist = mysql_fetch_array($resultdist);
$districtid = $rowdist['districtid'];
if (strlen($name) < 1) {
$flag1 = 'phpValidError';
}
if (isInvalidName($name)) {
$flag1 = 'phpValidError';
}
if (strlen($designation) < 1) {
$flag = 'phpValidError';
}
if (isInvalidName($designation)) {
$flag = 'phpValidError';
}
if (strlen($address1) < 1) {
$flag1 = 'phpValidError';
}
if (isInvalidAddress($address1)) {
$flag1 = 'phpValidError';
}
if (isInvalidAddress($address2)) {
$flag1 = 'phpValidError';
}
if (strlen($email) > 0) {
if (isInvalidEmail($email)) {
$flag1 = 'phpValidError';
}
}
if (isInvalidNumber($districtid)) {
$flag1 = 'phpValidError';
}
if (isStringNull($districtid)) {
$flag1 = 'phpValidError';
}
if (strlen($phone1) < 7) {
$flag1 = 'phpValidError';
}
if (isInvalidPhoneNo($phone1)) {
$flag1 = 'phpValidError';
}
if (isInvalidPhoneNo($mobile)) {
$flag1 = 'phpValidError';
}
if (strlen($user) < 5) {
$flag1 = 'phpValidError';
}
if (strlen($user) > 25) {
$flag1 = 'phpValidError';
}
if (!ereg('^[a-zA-Z][a-zA-Z0-9]{4,24}$', $user)) {
$flag1 = 'phpValidError';
}
if (strlen($pass) < 5) {
$flag1 = 'phpValidError';
}
if (strlen($pass) > 25) {
$flag1 = 'phpValidError';
}
if (!ereg('^[a-zA-Z]', $pass)) {
$flag1 = 'phpValidError';
}
$result = mysql_query("select * from gmo where name='" . $name . "' and officeaddress1='" . $address1 . "' and\n\t\t\t\tofficeaddress2='" . $address2 . "' and officephno1='" . $phone1 . "' and officephno2='" . $phone2 . "'\n\t\t\t\tand mobilenumber='" . $mobile . "' and emailid='" . $email . "' and designation='" . $designation . "'\n\t\t\t\tand districtid='" . $districtid . "' ") or die(mysql_error());
$intnameExists = mysql_num_rows($result);
if ($intnameExists > 0) {
$flag = 1;
} else {
if ($flag1 == 'phpValidError') {
} else {
$result1 = mysql_query("select * from user where username='******' ") or die(mysql_error());
$intUnameExists = mysql_num_rows($result1);
if ($intUnameExists > 0) {
$flag = 2;
} else {
$flag = 3;
mysql_query("insert into user\n\t\t\t\t\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t\t\t\t\t\tusername,\n\t\t\t\t\t\t\t\t\t\t\t\tuserpasswd,\n\t\t\t\t\t\t\t\t\t\t\t\tstatus,\n\t\t\t\t\t\t\t\t\t\t\t\tusertype\n\n\t\t\t\t\t\t\t\t\t\t\t)\n\t\t\t\t\t\t\t\t\t\t\tvalues\n\t\t\t\t\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t\t\t\t\t\t\t'" . preventInj($user) . "',\n\t\t\t\t\t\t\t\t\t\t\t\t\tpassword('" . preventInj($pass) . "'),\n\t\t\t\t\t\t\t\t\t\t\t\t\t'Pending',\n\t\t\t\t\t\t\t\t\t\t\t\t\t'GMO'\n\n\t\t\t\t\t\t\t\t\t\t\t)\n\t\t\t\t\t\t\t\t\t\t\t ") or die(mysql_error());
mysql_query("insert into gmo\n\t\t\t\t\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t\t\t\t\t\tname,\n\t\t\t\t\t\t\t\t\t\t\t\tdesignation,\n\t\t\t\t\t\t\t\t\t\t\t\tusername,\n\t\t\t\t\t\t\t\t\t\t\t\temailid,\n\t\t\t\t\t\t\t\t\t\t\t\tofficeaddress1,\n\t\t\t\t\t\t\t\t\t\t\t\tofficeaddress2,\n\t\t\t\t\t\t\t\t\t\t\t\tofficephno1,\n\t\t\t\t\t\t\t\t\t\t\t\tofficephno2,\n\t\t\t\t\t\t\t\t\t\t\t\tmobilenumber,\n\t\t\t\t\t\t\t\t\t\t\t\tstatus,\n\t\t\t\t\t\t\t\t\t\t\t\tdistrictid,\n\t\t\t\t\t\t\t\t\t\t\t\tstateid\n\n\t\t\t\t\t\t\t\t\t\t\t)\n\t\t\t\t\t\t\t\t\t\t\tvalues\n\t\t\t\t\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t\t\t\t\t\t'" . preventInj(trim($name)) . "',\n\t\t\t\t\t\t\t\t\t\t\t\t'" . preventInj(trim($designation)) . "',\n\t\t\t\t\t\t\t\t\t\t\t\t'" . preventInj(trim($user)) . "',\n\t\t\t\t\t\t\t\t\t\t\t\t'" . preventInj(trim($email)) . "',\n\t\t\t\t\t\t\t\t\t\t\t\t'" . preventInj(trim($address1)) . "',\n\t\t\t\t\t\t\t\t\t\t\t\t'" . preventInj(trim($address2)) . "',\n\t\t\t\t\t\t\t\t\t\t\t\t'" . preventInj(trim($phone1)) . "',\n\t\t\t\t\t\t\t\t\t\t\t\t'" . preventInj(trim($phone2)) . "',\n\t\t\t\t\t\t\t\t\t\t\t\t'" . preventInj(trim($mobile)) . "',\n\t\t\t\t\t\t\t\t\t\t\t\t'Pending',\n\t\t\t\t\t\t\t\t\t\t\t\t'" . trim($districtid) . "',\n\t\t\t\t\t\t\t\t\t\t\t\t'01'\n\n\t\t\t\t\t\t\t\t\t\t\t)\n\t\t\t\t\t\t\t\t\t\t") or die(mysql_error());
$description = "New gmo with username " . $user . " is registered";
insertEventData("Registration", "Registered new gmo", 'GMO', $description);
}
}
}
}
return $flag;
}
function addData()
{
$hospitalName = "";
$address1 = null;
$address2 = null;
$phone1 = null;
$email = "";
$phone2 = null;
$regno = null;
$mobile = null;
$user = null;
$pass = null;
$district = null;
$flag = 7;
$flag1 = null;
$intnameExists = 0;
if (isset($_GET['add'])) {
$name = $_GET['hname'];
$address1 = $_GET['address1'];
$address2 = $_GET['address2'];
$email = $_GET['email'];
$phone1 = $_GET['phonenumber1'];
$phone2 = $_GET['phonenumber2'];
$regno = $_GET['regno'];
$mobile = $_GET['mobilenumber'];
$user = $_GET['username'];
$pass = preventInj($_GET['password']);
$pincode = $_GET['pincode'];
$district = $_GET['district'];
$resultdist = mysql_query("select districtid from district where name='" . $_GET['district'] . "' ") or die(mysql_error());
$rowdist = mysql_fetch_array($resultdist);
$districtid = $rowdist['districtid'];
if (strlen($name) < 1) {
$flag1 = 'phpValidError';
}
if (isInvalidName($name)) {
$flag1 = 'phpValidError';
}
if (strlen($address1) < 1) {
$flag1 = 'phpValidError';
}
if (isInvalidAddress($address1)) {
$flag1 = 'phpValidError';
}
if (isInvalidAddress($address2)) {
$flag1 = 'phpValidError';
}
if (strlen($email) > 0) {
if (isInvalidEmail($email)) {
$flag1 = 'phpValidError';
}
}
if (isInvalidNumber($districtid)) {
$flag1 = 'phpValidError';
}
if (isStringNull($districtid)) {
$flag1 = 'phpValidError';
}
if (strlen($phone1) < 7) {
$flag1 = 'phpValidError';
}
if (isInvalidPhoneNo($phone1)) {
$flag1 = 'phpValidError';
}
if (isInvalidPhoneNo($mobile)) {
$flag1 = 'phpValidError';
}
if (isInvalidPhoneNo($phone2)) {
$flag1 = 'phpValidError';
}
if (strlen($pincode) > 0) {
if (strlen($pincode) != 6) {
$flag1 = 'phpValidError';
}
if (isInvalidNumber($pincode)) {
$flag1 = 'phpValidError';
}
}
if (isInvalidName($regno)) {
$flag1 = 'phpValidError';
}
if (strlen($user) < 5) {
$flag1 = 'phpValidError';
}
if (strlen($user) > 25) {
$flag1 = 'phpValidError';
}
if (!ereg('^[a-zA-Z][a-zA-Z0-9]{4,24}$', $user)) {
$flag1 = 'phpValidError';
}
if (strlen($pass) < 5) {
$flag1 = 'phpValidError';
}
if (strlen($pass) > 25) {
$flag1 = 'phpValidError';
}
if (!ereg('^[a-zA-Z]', $pass)) {
$flag1 = 'phpValidError';
}
$result = mysql_query("select * from hospital where name='" . $name . "' and hospitaladdress1='" . $address1 . "' and hospitaladdress2='" . $address2 . "' and hospitalphno1='" . $phone1 . "' and hospitalphno2='" . $phone2 . "'\n\t\t\tand mobilenumber='" . $mobile . "' and emailid='" . $email . "' and registerno='" . $regno . "' and \n\t\t\tdistrictid='" . $districtid . "' ") or die(mysql_error());
$intnameExists = mysql_num_rows($result);
if ($intnameExists > 0) {
$flag = 1;
} else {
if ($flag1 == 'phpValidError') {
} else {
$result1 = mysql_query("select * from user where username='******' ") or die(mysql_error());
$intUnameExists = mysql_num_rows($result1);
if ($intUnameExists > 0) {
$flag = 2;
} else {
mysql_query("insert into user\n\t\t\t\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t\t\t\t\tusername,\n\t\t\t\t\t\t\t\t\t\t\tuserpasswd,\n\t\t\t\t\t\t\t\t\t\t\tstatus,\n\t\t\t\t\t\t\t\t\t\t\tusertype\n\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t)\n\t\t\t\t\t\t\t\t\t\tvalues\n\t\t\t\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t\t\t\t\t\t'" . preventInj($user) . "',\n\t\t\t\t\t\t\t\t\t\t\t\tpassword('" . $pass . "'),\n\t\t\t\t\t\t\t\t\t\t\t\t'Pending',\n\t\t\t\t\t\t\t\t\t\t\t\t'HOSPITAL'\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t)\n\t\t\t\t\t\t\t\t\t\t ");
mysql_query("insert into hospital\n\t\t\t\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t\t\t\t\tname,\n\t\t\t\t\t\t\t\t\t\t\tusername,\n\t\t\t\t\t\t\t\t\t\t\temailid,\n\t\t\t\t\t\t\t\t\t\t\thospitaladdress1,\n\t\t\t\t\t\t\t\t\t\t\thospitaladdress2,\n\t\t\t\t\t\t\t\t\t\t\thospitalphno1,\n\t\t\t\t\t\t\t\t\t\t\thospitalphno2,\n\t\t\t\t\t\t\t\t\t\t\tmobilenumber,\n\t\t\t\t\t\t\t\t\t\t\tdistrictid,\n\t\t\t\t\t\t\t\t\t\t\tstateid,\n\t\t\t\t\t\t\t\t\t\t\tpincode,\n\t\t\t\t\t\t\t\t\t\t\tregisterno,\n\t\t\t\t\t\t\t\t\t\t\tstatus\n\t\t\t\t\t\t\t\t\t\t) \n\t\t\t\t\t\t\t\t\t\tvalues \n\t\t\t\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t\t\t\t\t'" . preventInj(trim($name)) . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . preventInj(trim($user)) . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . preventInj(trim($email)) . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . preventInj(trim($address1)) . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . preventInj(trim($address2)) . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . preventInj(trim($phone1)) . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . preventInj(trim($phone2)) . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . preventInj(trim($mobile)) . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . preventInj(trim($districtid)) . "',\n\t\t\t\t\t\t\t\t\t\t\t'01',\n\t\t\t\t\t\t\t\t\t\t\t'" . preventInj(trim($pincode)) . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . preventInj(trim($regno)) . "',\n\t\t\t\t\t\t\t\t\t\t\t'Pending'\n\t\t\t\t\t\t\t\t\t\t)\n\t\t\t\t\t\t\t\t\t");
$flag = 3;
$description = "New hospital with name " . $name . " is registered";
insertEventData("Registration", "Registered new hospital", $user, $description);
}
}
}
}
return $flag;
}
function addBulkCaseDetails($strId)
{
$blnFlag = "";
$username = $_SESSION['userName'];
$intDistrictId = trim($_POST['cmpDistrict']);
$intDiseaseId = trim($_POST['cmpDisease']);
$intReportedNo = trim($_POST['txtReportedNo']);
$intFatalNo = trim($_POST['txtFatalNo']);
if (isStringNull($intDistrictId)) {
$blnFlag = 'phpValidError';
}
if (isStringNull($intDiseaseId)) {
$blnFlag = 'phpValidError';
}
if (isInvalidNumber($intDistrictId)) {
$blnFlag = 'phpValidError';
}
if (isInvalidNumber($intDiseaseId)) {
$blnFlag = 'phpValidError';
}
if (isStringNull($intReportedNo)) {
$blnFlag = 'phpValidError';
}
if (isInvalidNumber($intReportedNo)) {
$blnFlag = 'phpValidError';
}
if (isInvalidNumber($intFatalNo)) {
$blnFlag = 'phpValidError';
}
if ($strId == 'add') {
$createdon = date("Y-m-d");
if ($blnFlag == 'phpValidError') {
} else {
mysql_query("insert into bulkcase\n\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t\tdistrictid,\n\t\t\t\t\t\t\t\tdiseaseid,\n\t\t\t\t\t\t\t\treportedcase,\n\t\t\t\t\t\t\t\tfatalcase,\n\t\t\t\t\t\t\t\tcreatedon,\n\t\t\t\t\t\t\t\tusername\n\t\t\t\t\t\t\t)\n\t\t\t\t\t\t\tvalues\n\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t\t'" . preventInj($intDistrictId) . "',\n\t\t\t\t\t\t\t\t'" . preventInj($intDiseaseId) . "',\n\t\t\t\t\t\t\t\t'" . preventInj($intReportedNo) . "',\n\t\t\t\t\t\t\t\t'" . preventInj($intFatalNo) . "',\n\t\t\t\t\t\t\t\t'" . $createdon . "',\n\t\t\t\t\t\t\t\t'" . preventInj($username) . "'\n\t\t\t\t\t\t\t)\n\t\t\t\t\t\t") or die(mysql_error());
$blnFlag = 'true';
$description = "";
insertEventData("Add_Bulk_Case_Report", "New_Bulk_Case_Reported", $username, $description);
}
} else {
if ($strId == 'edit') {
$intBulkCaseId = $_POST['txtBulkCaseId'];
if (isInvalidNumber($intBulkCaseId)) {
$blnFlag = 'phpValidError';
}
if ($blnFlag == 'phpValidError') {
} else {
mysql_query("UPDATE bulkcase SET\n\t\t\t\t\t\t\t\t\t\tdistrictid='" . preventInj($intDistrictId) . "',\n\t\t\t\t\t\t\t\t\t\tdiseaseid='" . preventInj($intDiseaseId) . "',\n\t\t\t\t\t\t\t\t\t\treportedcase='" . preventInj($intReportedNo) . "',\n\t\t\t\t\t\t\t\t\t\tfatalcase='" . preventInj($intFatalNo) . "'\n\t\t\t\t\t\t\t\tWHERE bulkcaseid='" . $intBulkCaseId . "' ") or die(mysql_error());
$description = "Bulk case report with id " . $intBulkCaseId . " is updated";
insertEventData("Update_Bulk_Case_Report ", "Bulk_Case_Report_Updated", $username, $description);
$blnFlag = 'success';
}
} else {
}
}
return $blnFlag;
}
function addData($uname, $id, $poId, $newPoId)
{
$flag = "";
$name = "";
$distId = "";
$latitude = "";
$longitude = "";
$pincode = "";
if ($id == 'add') {
$name = trim($_POST['txtName']);
$distId = trim($_POST['cboDistrict']);
$latitude = trim($_POST['txtLatitude']);
$longitude = trim($_POST['txtLongitude']);
$pincode = trim($_POST['txtPincode']);
if (strlen($name) < 1) {
$flag = 'phpValidError';
}
if (isInvalidName($name)) {
$flag = 'phpValidError';
}
if (isInvalidNumber($distId)) {
$flag = 'phpValidError';
}
if (strlen($pincode) != 6) {
$flag = 'phpValidError';
}
if (isInvalidNumber($pincode)) {
$flag = 'phpValidError';
}
if (isStringNull($latitude)) {
$flag = 'phpValidError';
}
if (isInvalidFloat($latitude)) {
$flag = 'phpValidError';
}
if (isStringNull($longitude)) {
$flag = 'phpValidError';
}
if (isInvalidFloat($longitude)) {
$flag = 'phpValidError';
}
$result = mysql_query("SELECT * FROM postoffice WHERE name='" . $name . "'\n\t\t\tAND districtid='" . $distId . "' AND pincode='" . $pincode . "' ") or die(mysql_error());
$intnameExists = mysql_num_rows($result);
if ($intnameExists > 0) {
$flag = 'false';
} else {
if ($flag == 'phpValidError') {
} else {
mysql_query("insert into postoffice\n\t\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t\t\tname,\n\t\t\t\t\t\t\t\t\tdistrictid,\n\t\t\t\t\t\t\t\t\tpincode,\n\t\t\t\t\t\t\t\t\tlatitude,\n\t\t\t\t\t\t\t\t\tlongitude\n\t\t\t\t\t\t\t\t)\n\t\t\t\t\t\t\t\tvalues\n\t\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t\t\t'" . preventInj($name) . "',\n\t\t\t\t\t\t\t\t\t'" . preventInj($distId) . "',\n\t\t\t\t\t\t\t\t\t'" . preventInj($pincode) . "',\n\t\t\t\t\t\t\t\t\t'" . preventInj($latitude) . "',\n\t\t\t\t\t\t\t\t\t'" . preventInj($longitude) . "'\n\t\t\t\t\t\t\t\t)\n\t\t\t\t\t\t\t") or die(mysql_error());
$flag = 'true';
$usertype = $_SESSION['userType'];
$username = $_SESSION['userName'];
$description = "Post office name " . trim($name) . " is added";
insertEventData('Add_Post_Office', "Add_new_Postoffice", $username, $description);
}
}
} else {
if ($id == 'edit') {
$postOfficeId = $poId;
$name = trim($_POST['txtName']);
$distId = trim($_POST['cboDistrict']);
$latitude = trim($_POST['txtLatitude']);
$longitude = trim($_POST['txtLongitude']);
$pincode = trim($_POST['txtPincode']);
if (strlen($name) < 1) {
$flag = 'phpValidError';
}
if (isInvalidName($name)) {
$flag = 'phpValidError';
}
if (isInvalidNumber($distId)) {
$flag = 'phpValidError';
}
if (strlen($pincode) != 6) {
$flag = 'phpValidError';
}
if (isInvalidNumber($pincode)) {
$flag = 'phpValidError';
}
if (isStringNull($latitude)) {
$flag = 'phpValidError';
}
if (isInvalidFloat($latitude)) {
$flag = 'phpValidError';
}
if (isStringNull($longitude)) {
$flag = 'phpValidError';
}
if (isInvalidFloat($longitude)) {
$flag = 'phpValidError';
}
if (isInvalidNumber($postOfficeId)) {
$flag = 'phpValidError';
}
if ($flag == 'phpValidError') {
} else {
mysql_query("UPDATE postoffice SET\n\t\t\t\t\t\t\t\t\tname ='" . preventInj($name) . "',\n\t\t\t\t\t\t\t\t\tdistrictid='" . preventInj($distId) . "',\n\t\t\t\t\t\t\t\t\tpincode='" . preventInj($pincode) . "',\n\t\t\t\t\t\t\t\t\tlatitude='" . preventInj($latitude) . "',\n\t\t\t\t\t\t\t\t\tlongitude='" . preventInj($longitude) . "'\n\t\t\t\t\t\t\t\tWHERE postofficeid='" . $postOfficeId . "' ") or die(mysql_error());
$username = $_SESSION['userName'];
$description = "Postoffice name " . $name . " is updated";
insertEventData('Update_Post_Office', "Update_Post_Office_Details", $username, $description);
$flag = 'success';
}
} else {
if ($id == 'editNew') {
$newpostOfficeId = $newPoId;
$name = trim($_POST['txtName']);
$distId = trim($_POST['cboDistrict']);
$latitude = trim($_POST['txtLatitude']);
$longitude = trim($_POST['txtLongitude']);
$pincode = trim($_POST['txtPincode']);
if (strlen($name) < 1) {
$flag = 'phpValidError';
}
if (isInvalidName($name)) {
$flag = 'phpValidError';
}
if (isInvalidNumber($distId)) {
$flag = 'phpValidError';
}
if (strlen($pincode) != 6) {
$flag = 'phpValidError';
}
if (isInvalidNumber($pincode)) {
$flag = 'phpValidError';
}
if (isStringNull($latitude)) {
$flag = 'phpValidError';
}
if (isInvalidFloat($latitude)) {
$flag = 'phpValidError';
}
if (isStringNull($longitude)) {
$flag = 'phpValidError';
}
if (isInvalidFloat($longitude)) {
$flag = 'phpValidError';
}
if (isInvalidNumber($newpostOfficeId)) {
$flag = 'phpValidError';
}
$result = mysql_query("SELECT * FROM postoffice WHERE name='" . $name . "'\n\t\t\tAND districtid='" . $distId . "' AND pincode='" . $pincode . "' ") or die(mysql_error());
$intnameExists = mysql_num_rows($result);
if ($intnameExists > 0) {
$flag = 'false';
} else {
if ($flag == 'phpValidError') {
} else {
mysql_query("insert into postoffice\n\t\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t\t\tname,\n\t\t\t\t\t\t\t\t\tdistrictid,\n\t\t\t\t\t\t\t\t\tpincode,\n\t\t\t\t\t\t\t\t\tlatitude,\n\t\t\t\t\t\t\t\t\tlongitude\n\t\t\t\t\t\t\t\t)\n\t\t\t\t\t\t\t\tvalues\n\t\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t\t\t'" . preventInj($name) . "',\n\t\t\t\t\t\t\t\t\t'" . preventInj($distId) . "',\n\t\t\t\t\t\t\t\t\t'" . preventInj($pincode) . "',\n\t\t\t\t\t\t\t\t\t'" . preventInj($latitude) . "',\n\t\t\t\t\t\t\t\t\t'" . preventInj($longitude) . "'\n\t\t\t\t\t\t\t\t)\n\t\t\t\t\t\t\t") or die(mysql_error());
mysql_query("DELETE FROM newpostoffice WHERE postofficeid='" . $newpostOfficeId . "' ") or die(mysql_error());
$flag = 'newAdd';
$username = $_SESSION['userName'];
$description = "Post office name " . trim($name) . " is deleted from pending list and new postoffice added";
insertEventData('Add_Post_Office', "Add_Pending_Post_office", $username, $description);
}
}
} else {
}
}
}
return $flag;
}
