if (strtolower($getit[0]) == 'quarterly') { $sendthis = "Due date for 1st Q is {$getnow['qtrdue1']},2nd Q is {$getnow['qtrdue2']}, 3rd Q is {$getnow['qtrdue3']},4th Q is {$getnow['qtrdue4']}"; } elseif (strtolower($getit[0]) == 'semi-annual') { $sendthis = "Due date for 1st sem is {$getnow['semdue1']},2nd sem is {$getnow['semdue2']}"; } elseif (strtolower($getit[0]) == 'annual') { $getdue1 = SelectDataWhere($dbtype, $dbLink, 'ebpls_buss_penalty', ""); $getnow = FetchRow($dbtype, $getdue); $sendthis = "Due date for this year is {$getnow['renewaldate']}"; } } elseif ($keyword == 'req') { } } } //send it $res = InsertQuery($dbtype, $dbLink, "sms_send", "", "'','{$cellnum}','{$sendthis}',1,now()"); $res = InsertQuery($dbtype, $dbLink, "sms_archive", "", "'','{$cellnum}','{$sendthis}',1,now()"); //flush $delsms = DeleteQuery($dbtype, $dbLink, "sms", "smsid<>0 order by smsid asc limit 1"); } if ($sendthis != '') { echo "Message:" . $sendthis . " has been sent to " . $celnum; } else { echo "No New Messages Found. Will Search Again"; } sleep(2); setUrlRedirect('sms_server.php'); ?>
} if ($blak == 1) { ?> <body onload='javascript:alert("Please Input Valid GSM Number: +639191234567");'> </body> <?php } if ($blak == 0 || $blak == '') { $addown = new TaxPayer(); $strValues = "owner_first_name='{$owner_first_name}',owner_middle_name='{$owner_middle_name}',\r\n \t owner_last_name='{$owner_last_name}',owner_street='{$owner_street}',\r\n owner_barangay_code='{$owner_barangay_code}',owner_zone_code='{$owner_zone_code}',\r\n owner_district_code='{$owner_district_code}',owner_city_code='{$owner_city_code}',\r\n owner_province_code='{$owner_province_code}',owner_zip_code='{$owner_zip_code}',\r\n owner_citizenship='{$owner_citizenship}',owner_civil_status='{$owner_civil_status}',\r\n owner_gender='{$owner_gender}',owner_tin_no='{$owner_tin_no}',\r\n owner_icr_no='{$owner_icr_no}',owner_phone_no='{$owner_phone_no}',\r\n owner_gsm_no='{$owner_gsm_no}',owner_email_address='{$owner_email_address}',\r\n owner_others='{$owner_others}',owner_birth_date='{$owner_birth_date}',\r\n owner_lastupdated=now(),owner_lastupdated_by='{$usern}'"; $strWhere = "owner_id={$owner_id}"; $addown->UpdateTaxPayer($strValues, $strWhere); } // } $redito = "index.php?part=4&itemID_=1221&permit_type=" . $tag . "&stat=" . $stat . "&owner_id=" . $owner_id . "&upOwner=UPDATE&business_id=" . $business_id . "&busItem=" . $permit_type . "&frmedit=yes"; setUrlRedirect($redito); } if ($comm != 'Add') { $reload = SelectDataWhere($dbtype, $dbLink, $owner, "where owner_id ={$owner_id}"); $owner = FetchRow($dbtype, $reload); } elseif ($comm == 'Add' and $owner_id != '') { $reload = SelectDataWhere($dbtype, $dbLink, $owner, "where owner_id ={$owner_id}"); $owner = FetchRow($dbtype, $reload); } ?> <html> <title>Owner Details</title> <head> <link rel="stylesheet" href="stylesheets/default.css" type="text/css"/> </head>
//Robert } else { if ($aTAXFEEid == 0) { echo "<p align=center>Error encountered... Please report immediately to your IT personnel.</p>"; } else { //echo "tama naman..."; if ($rangeind[$ctr] == '1') { if (is_numeric($rangeamount[$ctr])) { $INSERTdata = mysql_query("INSERT INTO ebpls_buss_taxrange (taxfeeid,rangelow,rangehigh,rangeamount,rangeind,rangestatus,datecreated) VALUES ('{$aTAXFEEid}','{$rangelow[$ctr]}','{$rangehigh[$ctr]}','{$rangeamount[$ctr]}','{$rangeind[$ctr]}','A',Now())", $link2db); // and rangeid='$rangeID[$ctr]' //$myid = mysql_query("UPDATE $tbl_current SET naturedesc='$nidescription' WHERE natureid='$natureid' ",$link2db); //$validateID=5; //echo "<p align=center><font color=#ff0033><b><i>Record successfully updated!!!</font></i></b></p>"; //include'validate-inc.php'; $ctrtaxfeeid = ''; setUrlRedirect("index.php?natureid={$natureid}&action_=1&actionID=1&part=4&class_type=Preference&pref_type=Business&selMode=ebpls_nbusiness&natureaction=Edit&orderbyasdes=1&reftype=bus"); } else { echo "<div align=center><font color=red><b><i>Invalid Amount ({$rangeamount[$ctr]})</i></b></font></div>"; } } if ($rangeind[$ctr] == '2') { $openpar = substr_count($rangeamount[$ctr], '('); $closepar = substr_count($rangeamount[$ctr], ')'); $closepar1 = $closepar - 2; if ($openpar == $closepar1) { $INSERTdata = mysql_query("INSERT INTO ebpls_buss_taxrange (taxfeeid,rangelow,rangehigh,rangeamount,rangeind,rangestatus,datecreated) VALUES ('{$aTAXFEEid}','{$rangelow[$ctr]}','{$rangehigh[$ctr]}','{$rangeamount[$ctr]}','{$rangeind[$ctr]}','A',Now())", $link2db); // and rangeid='$rangeID[$ctr]' //$myid = mysql_query("UPDATE $tbl_current SET naturedesc='$nidescription' WHERE natureid='$natureid' ",$link2db); $validateID = 5; //echo "<p align=center><font color=#ff0033><b><i>Record successfully updated!!!</font></i></b></p>"; //include'validate-inc.php';
<title>SMS Sender </title> <div align = center> <table border=0> <td> </td> </table> </div> <?php $getsend = SelectDataWhere($dbtype, $dbLink, "sms_send", "where new_sms=1 limit 1"); $getcnt = NumRows($dbtype, $getsend); $smsid = $getit[0]; while ($getit = FetchRow($dbtype, $getsend)) { $smsid = $getit[0]; $tym = date('H:m:s'); $x = 1; echo "Sending Message: {$getit['2']} to {$getit['1']}<BR>"; $tym = date('H:m:s'); $mnum = $getit[1]; $mmsg = $getit[2]; $fileopened = fopen("textfile", "wb"); fwrite($fileopened, "To: {$mnum}\r\n\r\n"); fwrite($fileopened, "{$mmsg}"); fclose($fileopened); $nRand = rand(00, 99999); $copfile = shell_exec("cp textfile /home/site/gsm/outgoing/textfile{$nRand}"); sleep(2); $updateit = DeleteQuery($dbtype, $dbLink, "sms_send", "smsid={$smsid}"); $archiveit = InsertQuery($dbtype, $dbLink, "sms_archive", "", "'','{$mnum}','{$mmsg}',now()"); } setUrlRedirect("sms_sender.php");