<?php
if (tp('verif') == 1) {
model::load('gestionvilla', 'resiliercontrat');
if (!compare_date(tp('idcontrat'), tp('date'))) {
exit("3");
} else {
if (!setcontrat(tp('idcontrat'), tp('date'), tp('pjid'))) {
exit("2");
} else {
setvilla(tp('villa'));
exit("1");
}
}
} else {
view::load('gestionvilla', 'resiliercontrat');
}
break;
}
//Recherche dans les numéros
$start_num = ${bull_num_deb_ . "" . $id};
if ($f_bull_deb_id) {
$restrict_num = compare_date($f_bull_deb_id);
$restrict_date = "";
} else {
if ($start_num) {
$restrict_num = " and bulletin_numero like '%" . $start_num . "%' ";
$restrict_date = "";
}
}
// Recherche dans les dates et libellés de période
if (!$restrict_num) {
$restrict_date = compare_date($bull_date_start, $bull_date_end);
}
// nombre de références par pages (12 par défaut)
if (!isset($opac_bull_results_per_page)) {
$opac_bull_results_per_page = 12;
}
if (!$page) {
$page = 1;
}
$debut = ($page - 1) * $opac_bull_results_per_page;
$limiter = " LIMIT {$debut},{$opac_bull_results_per_page}";
//affichage
print pmb_bidi(aff_notice($id));
//Recherche par numéro
$num_field_start = "\n\t\t\t\t\t<input type='hidden' name='f_bull_deb_id' id='f_bull_deb_id' />\n\t\t\t\t\t<input id='bull_num_deb_{$id}' name='bull_num_deb_{$id}' type='text' size='10' completion='bull_num' autfield='f_bull_deb_id' value='" . $start_num . "'>";
//Recherche par date
$SMS_CONTENT = sprintf(_("OA公告,来自%s标题:%s"), $USER_NAME, $SUBJECT);
if ($SUMMARY) {
$SMS_CONTENT .= _("内容简介:") . $SUMMARY;
}
if ($USER_ID_STR != "") {
send_mobile_sms_user($SEND_TIME, $_SESSION['LOGIN_USER_ID'], $USER_ID_STR, $SMS_CONTENT, 1);
}
}
include_once "inc/itask/itask.php";
mobile_push_notification(userid2uid($USER_ID_STR), $_SESSION['LOGIN_USER_NAME'] . _("：") . _("请查看公告通知") . _("标题：") . csubstr($SUBJECT, 0, 20), "notify");
$WX_OPTIONS = array("module" => "notify", "module_action" => "notify.read", "user" => $USER_ID_STR, "content" => $_SESSION['LOGIN_USER_NAME'] . _("：") . _("请查看公告通知") . _("标题：") . csubstr($SUBJECT, 0, 20), "params" => array("NOTIFY_ID" => $NOTIFY_ID));
wxqy_sms($WX_OPTIONS);
}
if ($PUBLISH == "2") {
$SMS_CONTENT = _("请审批公告通知！") . "\n" . _("标题：") . csubstr($SUBJECT, 0, 100);
if (compare_date($BEGIN_DATE1, $CUR_DATE) == 1) {
$SEND_TIME = $BEGIN_DATE1;
}
$REMIND_URL = "1:notify/auditing/unaudited.php";
if ($SMS_REMIND == "on" && $AUDITER != "" && $AUDITER != $_SESSION['LOGIN_USER_ID']) {
send_sms($SEND_TIME, $_SESSION['LOGIN_USER_ID'], $AUDITER, 1, $SMS_CONTENT, $REMIND_URL);
}
if ($SMS2_REMIND == "on") {
$SMS_CONTENT = sprintf(_("请审批OA公告,来自%s"), $_SESSION['LOGIN_USER_NAME'] . ":" . $SUBJECT);
if ($SUMMARY) {
$SMS_CONTENT .= _("内容简介:") . $SUMMARY;
}
if ($AUDITER != "" && $AUDITER != $_SESSION['LOGIN_USER_ID']) {
send_mobile_sms_user($SEND_TIME, $_SESSION['LOGIN_USER_ID'], $AUDITER, $SMS_CONTENT, 1);
}
}
function cf7_custom_form_validation($result, $tag)
{
$type = $tag['type'];
$name = $tag['name'];
if ($type == 'text*' && $_POST[$name] == '') {
$result['valid'] = false;
$result['reason'][$name] = wpcf7_get_message('invalid_required');
}
//__________________________________________________________________________________________________
//Comparision date
if (isset($_POST['date1'])) {
$date1 = $_POST['date1'];
}
// ensure value is set before continuing @tufandr
if (isset($_POST['date2'])) {
$date2 = $_POST['date2'];
}
//CheckInDate
if ($name == 'date1') {
if (!compare_date($date1, $date2)) {
$result['valid'] = false;
$result['reason'][$name] = 'Logical Error: Check in date should be before check out date';
}
}
//__________________________________________________________________________________________________
//CheckOutDate
if ($name == 'date2') {
if (!compare_date($date1, $date2)) {
$result['valid'] = false;
$result['reason'][$name] = 'Logical Error: Check out date should be After check in date';
}
}
//__________________________________________________________________________________________________
//url
if ($name == 'url') {
$url = $_POST['url'];
if ($url != '') {
if (get_valid_url($url)) {
$result['valid'] = true;
} else {
$result['valid'] = false;
$result['reason'][$name] = 'Entered URL is invalid.';
}
}
}
//__________________________________________________________________________________________________
//emailAddress
if ($name == 'emailAddress' | 'your-email') {
$emailAddress = $_POST['emailAddress'];
if ($emailAddress != '') {
if (substr($emailAddress, 0, 1) == '.' || !preg_match('/^([*+!.&#$¦\'\\%\\/0-9a-z^_`{}=?~:-]+)@(([0-9a-z-]+\\.)+[0-9a-z]{2,4})$/i', $emailAddress)) {
$result['valid'] = false;
$result['reason'][$name] = 'Entered Email is Invalid.';
}
}
}
//__________________________________________________________________________________________________
//datemdy
if ($name == 'datemdy') {
$datemdy = $_POST['datemdy'];
if ($datemdy != '') {
if (!preg_match('/^([0-9]{2})\\/([0-9]{2})\\/([0-9]{4})$/', $datemdy)) {
$result['valid'] = false;
$result['reason'][$name] = 'Enter Date in MM/DD/YYYY Format';
}
}
}
//__________________________________________________________________________________________________
//US Zip code validation
//USZipCode
if ($name == 'USZipCode') {
$USZipCode = $_POST['USZipCode'];
if ($USZipCode != '') {
// if(!preg_match('/^([0-9]{5})(-[0-9]{4})?$/i', $USZipCode)) {
if (!preg_match('/^\\d{5}(-\\d{4})?$/', $USZipCode)) {
$result['valid'] = false;
$result['reason'][$name] = 'Entered Zipcode is Invalid';
}
}
}
//__________________________________________________________________________________________________
// CANADA Zip code validation
//CANZipCode
if ($name == 'CANZipCode') {
$CANZipCode = $_POST['CANZipCode'];
if ($CANZipCode != '') {
if (!preg_match('/^[ABCEGHJKLMNPRSTVXY]{1}\\d{1}[A-Z]{1} *\\d{1}[A-Z]{1}\\d{1}$/', $CANZipCode)) {
$result['valid'] = false;
$result['reason'][$name] = 'Entered Zipcode is Invalid';
}
}
}
//__________________________________________________________________________________________________
// US and CANADA Zip code validation
//USCANZipCode
if ($name == 'USCANZipCode') {
$USCANZipCode = $_POST['USCANZipCode'];
if ($USCANZipCode != '') {
if (!preg_match('/^[ABCEGHJKLMNPRSTVXY]{1}\\d{1}[A-Z]{1} *\\d{1}[A-Z]{1}\\d{1}$/', $USCANZipCode)) {
if (!preg_match('/^\\d{5}(-\\d{4})?$/', $USCANZipCode)) {
$result['valid'] = false;
$result['reason'][$name] = 'Entered Zipcode is Invalid';
}
}
}
}
//__________________________________________________________________________________________________
// Indian Postal code validation
//inPostalCode
if ($name == 'inPostalCode') {
$inPostalCode = $_POST['inPostalCode'];
if ($inPostalCode != '') {
if (!preg_match('/^[0-9]{6,6}$/', $inPostalCode)) {
$result['valid'] = false;
$result['reason'][$name] = 'Entered Pin code for India is Invalid';
}
}
}
//__________________________________________________________________________________________________
//This section updated on 22nd March 2013
// It will accept character, character + numeric value
// It will not accept special characters
//fullName
$allNames = array('fullName', 'fullName1', 'your-name');
foreach ($allNames as $uniNames) {
if ($name == $uniNames) {
$fullName = $_POST[$uniNames];
if ($fullName != '') {
if (!preg_match('/^[A-Z0-9][a-zA-Z0-9 ]+$/i', $fullName)) {
$result['valid'] = false;
$result['reason'][$name] = 'Please Enter a Valid Name';
}
if (is_numeric($fullName)) {
$result['valid'] = false;
$result['reason'][$name] = 'Please Enter a Valid Name';
}
}
}
}
//__________________________________________________________________________________________________
//acceptNum
$acceptNumbers = array('acceptNumber', 'acceptNumber1', 'acceptNumber2', 'acceptNumber3', 'acceptNumber4', 'acceptNumber5', 'acceptNumber6');
foreach ($acceptNumbers as $acceptNumber) {
if ($name == $acceptNumber) {
$acceptNum = $_POST[$acceptNumber];
if ($acceptNum != '') {
if (ctype_digit($acceptNum)) {
$result['valid'] = true;
} else {
$result['valid'] = false;
$result['reason'][$name] = 'Please Enter Only Numbers';
}
}
}
}
//__________________________________________________________________________________________________
//faxNumber
$faxNumbers = array('faxNumber', 'faxNumber1', 'faxNumber2', 'faxNumber3', 'faxNumber4', 'faxNumber5', 'faxNumber6');
foreach ($faxNumbers as $faxNum) {
if ($name == $faxNum) {
$faxNumber = $_POST[$faxNum];
$contRegex = '/^(?:1(?:[. -])?)?(?:\\((?=\\d{3}\\)))?([2-9]\\d{2})(?:(?<=\\(\\d{3})\\))? ?(?:(?<=\\d{3})[.-])?([2-9]\\d{2})[. -]?(\\d{4})(?: (?i:ext)\\.? ?(\\d{1,5}))?$/';
if ($faxNumber != '') {
if (!preg_match($contRegex, $faxNumber) && strlen($faxNumber) > 10 && strlen($faxNumber) < 18) {
$result['valid'] = false;
$result['reason'][$name] = 'Entered Fax Number is Invalid';
}
}
}
}
//__________________________________________________________________________________________________
//Agreement fields with the expected values. Ex. write ,,yes" to agree
$agreement = array('agreement', 'agreement1', 'agreement2');
$expectedValues = array('yes', 'Yes', 'YES');
foreach ($agreement as $a => $aValue) {
if ($name == $aValue) {
foreach ($expected_values as $i => $eValue) {
if ($eValue == $_POST[$name]) {
$result['valid'] = true;
break;
} else {
$result['valid'] = false;
$result['reason'][$name] = 'You did not agree with the terms';
}
}
}
}
//__________________________________________________________________________________________________
//Only Characters
$OnlyChars = array('onlyChar', 'onlyChar1', 'onlyChar2');
foreach ($OnlyChars as $OnlyChar) {
if ($name == $OnlyChar) {
$onlyChar = $_POST[$OnlyChar];
if ($onlyChar != '') {
$containsLettersOrNumbers = preg_match('~[0-9a-z]~i', $onlyChar) > 0;
if (!$containsLettersOrNumbers || is_numeric($onlyChar) || strlen($onlyChar > 64)) {
$result['valid'] = false;
$result['reason'][$name] = 'Please Enter Only Characters';
}
if (is_numeric($onlyChar)) {
$result['valid'] = false;
$result['reason'][$name] = 'Please Enter Only Characters';
}
}
}
}
//__________________________________________________________________________________________________
//validPhone
/*
49-4312 / 777 777
+1 (305) 613-0958 x101
(305) 613 09 58 ext 101
3056130958
+33 1 47 37 62 24 extension 3
(016977) 1234
04312 - 777 777
91-12345-12345
+58 295416 7216
*/
$phoneNumbersAll = array('validPhone', 'validPhone1', 'validPhone2', 'validPhone3', 'validPhone4', 'validPhone5', 'validPhone6');
foreach ($phoneNumbersAll as $validPhoneVal) {
if ($name == $validPhoneVal) {
$validPhone = $_POST[$validPhoneVal];
if ($validPhone != '') {
if (preg_match('/^(?:1(?:[. -])?)?(?:\\((?=\\d{3}\\)))?([2-9]\\d{2})(?:(?<=\\(\\d{3})\\))? ?(?:(?<=\\d{3})[.-])?([2-9]\\d{2})[. -]?(\\d{4})(?: (?i:ext)\\.? ?(\\d{1,5}))?$/', $validPhone) || preg_match('/^([\\+][0-9]{1,3}[\\ \\.\\-])?([\\(]{1}[0-9]{2,6}[\\)])?([0-9\\ \\.\\-\\/]{3,20})((x|ext|extension)[\\ ]?[0-9]{1,4})?$/', $validPhone) && strlen($validPhone) > 9 && strlen($validPhone) < 30 && (int) $validPhone) {
//$result['valid'] = true;
} else {
$result['valid'] = false;
$result['reason'][$name] = 'Entered Phone Number is Invalid';
}
}
}
}
//__________________________________________________________________________________________________
return $result;
}
$row = mysql_fetch_object($result);
$query2 = "select * from CAX.disponibilidad where disponibilidad.idmiembro='" . $id . "'and((fechaInicio between '" . $desde . "' and '" . $hasta . "') or ( fechaFin between '" . $desde . "' and '" . $hasta . "'));";
$result2 = mysql_query($query2) or die('Consulta fallida: ' . mysql_error());
$numero2 = mysql_num_rows($result2);
$row2 = mysql_fetch_object($result2);
if ($numero !== 0) {
echo "<script type='text/javascript'>";
echo "alert('Alguna de las Fechas ya Existe!');";
echo "location.href='../disponibilidad.php?owner&idmiembro=" . $id . "'";
echo "</script>";
} elseif ($numero2 !== 0) {
echo "<script type='text/javascript'>";
echo "alert('Ya Existen Fechas dentro de Desde Y Hasta !');";
echo "location.href='../disponibilidad.php?owner&idmiembro=" . $id . "'";
echo "</script>";
} elseif (compare_date($desde, $hasta) == true) {
echo "<script type='text/javascript'>";
echo "alert('Fecha Desde es Posterior a Fecha Hasta !');";
echo "location.href='../disponibilidad.php?owner&idmiembro=" . $id . "'";
echo "</script>";
} else {
$insert = "INSERT INTO `CAX`.`disponibilidad` (`idmiembro`, `fechaInicio`, `fechaFin`, `iddispo`) VALUES('{$id}','{$desde}','{$hasta}', 2)";
if ($id !== '' && $desde !== '' && $hasta !== '') {
mysql_query($insert) or die('Consulta fallida: ' . mysql_error());
$query = "UPDATE CAX.miembro SET iddispo=2 WHERE idmiembro='" . $id . "';";
mysql_query($query) or die('Consulta fallida: ' . mysql_error());
header("Location:../disponibilidad.php?owner&idmiembro=" . $id . "");
}
}
} else {
echo "<script type='text/javascript'>";
$user_aktiv = $this->session->userdata("userid");
$blnj = "<select id='bulan' name='bulan'></select>";
$thnj = "<select id='thn' name='thn'></select>";
$img = "<img src='" . base_url() . "asset/images/printer.png' id='printing' title='Print Report' class='xx'>";
echo "<form id='frm1' name='frm1' action='' method='post'>";
panel_begin('Daftar SPB,Perpanjang SPB', '', "Filter by Bulan :," . $blnj . ",Tahun :," . $thnj . ", ", "{$img}");
panel_multi('daftarspb', 'block');
$zb = new zetro_listBuilder('asset/bin/zetro_form.cfg');
$zb->ListHeader('Spb', '100%', 'listTable');
$no = 0;
//($page+1);
foreach ($list->result_array() as $lst) {
$no++;
echo "<tr class='xx' id='" . $lst['no_spb'] . "' align='center'>\r\n\t\t <td class='kotak'>{$no}</td>\r\n\t \t <td class='kotak'>" . $lst['no_spb'] . "</td>\r\n\t\t <td class='kotak'>" . tglfromSql($lst['tgl_spb']) . "</td>\r\n\t\t <td class='kotak' align='left'>" . $lst['nama_spb'] . "</td>\r\n\t\t <td class='kotak' align='left'>" . $lst['ktp_spb'] . "</td>\r\n\t\t <td class='kotak' align='left'>" . $lst['id_barang'] . "</td>\r\n\t\t <td class='kotak' align='right'>" . number_format($lst['taksir_spb'], 2) . "</td>\r\n\t\t <td class='kotak' align='right'>" . number_format($lst['nilai_spb'], 2) . "</td>\r\n\t\t <td class='kotak'>" . $lst['jw_spb'] . "</td>\r\n\t\t <td class='kotak'>" . tglfromSql($lst['jt_spb']) . "</td>";
$ppke = rdb("perpanjang_spb", "pp_ke", 'pp_ke', "where no_spb='" . $lst['no_spb'] . "'");
echo compare_date($lst['jt_spb'], date('Y-m-d')) ? "<td class='kotak' width='5%'>" . perpanjang($lst['no_spb'], $ppke) . "<td>" : "<td class='kotak' width='5%'> </td></tr>";
}
echo "</tbody></table>\n";
panel_multi_end();
panel_multi('perpanjangspb');
?>
<table id='listdata' style='border-collapse:collapse'>
<thead>
<tr class='header'>
<th class='kotak' rowspan='2' width='20%'>URAIAN</th>
<th class='kotak' colspan='2' width='12%'>PENJUALAN</th>
<th class='kotak' rowspan='2' width='10%'>NAMA NASABAH</th>
<th class='kotak' rowspan='2' width='10%'>TAKSIR</th>
<th class='kotak' rowspan='2' width='10%'>NILAI TAKSIR</th>
<th class='kotak' rowspan='2' width='5%'>WAKTU</th>
<th class='kotak' rowspan='2' width='8%'>JATUH TEMPO</th>
<?php
include "inc/connect.php";
include "inc/functions.php";
if ($_GET) {
$id = nettoyage($_GET["id"]);
echo "compte creer";
$date_now = strtotime(date("Y-m-d H:i:s"));
$date_db = date_db($connexion, $id);
$date_db = strtotime($date_db[0]['date']);
compare_date($connexion, $id, $date_now, $date_db);
header('Refresh: 5; URL=index.php');
} else {
}
function perpanjang($no_spb, $pp_ke = 1, $showtgl = false, $bayar = false)
{
$jtspb = rdb('spb', 'tgl_spb', 'tgl_spb', "where no_spb='{$no_spb}'");
$nextjtspb = getNextDays($jtspb, $pp_ke * 30);
$nextjtspb2 = getNextDays($jtspb, ($pp_ke + 1) * 30);
$bataslelang = getNextDays($nextjtspb, 13);
$today = date('Y-m-d');
$stat = rdb('perpanjang_spb', 'pp_ke', 'pp_ke', "where no_spb='" . $no_spb . "' and pp_ke='{$pp_ke}'");
$action = rdb('perpanjang_spb', 'pp_stat', 'pp_stat', "where no_spb='" . $no_spb . "' and pp_ke='{$pp_ke}'");
$bayare = $bayar == true && $pp_ke > 1 ? rdb('perpanjang_spb', 'pp_stat', 'pp_stat', "where no_spb='" . $no_spb . "' and pp_ke='" . ($pp_ke - 1) . "'") : '';
$bunga = rdb('spb', 'taksir_spb', 'taksir_spb', "where no_spb='{$no_spb}'");
$bunga = $bunga * 10 / 100;
if ($stat == '') {
if (compare_date($today, $bataslelang) == true && compare_date($today, $nextjtspb) == false) {
return "<img class='aksi' src='" . base_url() . "/asset/images/icon-25.gif' width='20' height='20' title='Klik untuk process perpanjang' onclick=\"aksi_click('{$no_spb}','{$pp_ke}','{$bunga}')\";>";
} else {
return compare_date($nextjtspb2, $today) == false ? $bayar == true && $bayare == 'Y' || $pp_ke == '1' ? "<img src='" . base_url() . "/asset/images/checkout.gif' title='Click untuk transaksi bayar' onclick=\"aksi_click('{$no_spb}','{$pp_ke}','{$bunga}')\">" : false : "<img src='" . base_url() . "/asset/images/8.png' title='Tidak di perpanjang lanjut untuk process lelang'>";
}
} else {
if ($action == 'Y') {
return $showtgl == false ? "<img src='" . base_url() . "/asset/images/iconic.png' ondblclick=\"reset_upd('{$no_spb}','{$pp_ke}','');\" title='Telah di perpanjang " . $stat . " kali.\nTanggal Jatuh Tempo berikutnya :" . tglfromSql(getNextDays($jtspb, ($stat + 1) * 30)) . "'>" : ShortTgl($nextjtspb2);
} else {
if ($action == 'N') {
return "<img src='" . base_url() . "/asset/images/8.png' ondblclick=\"reset_upd('{$no_spb}','{$pp_ke}','Y');\" title='Tidak di perpanjang lanjut untuk process lelang'>";
} else {
if ($action == 'L') {
return "<img src='" . base_url() . "/asset/images/bullet.png' title='Lunas'>";
} else {
return false;
}
}
}
}
}
