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");
