function systemColorBuild($red, $green, $blue)
{
if ($red < 0) {
$red = 0;
}
if ($green < 0) {
$green = 0;
}
if ($blue < 0) {
$blue = 0;
}
if ($red > 255) {
$red = 255;
}
if ($green > 255) {
$green = 255;
}
if ($blue > 255) {
$blue = 255;
}
$red = STR_PAD(dechex($red), 2, "0", STR_PAD_LEFT);
$green = STR_PAD(dechex($green), 2, "0", STR_PAD_LEFT);
$blue = STR_PAD(dechex($blue), 2, "0", STR_PAD_LEFT);
$color = strtoupper($red . $green . $blue);
// $color = strtoupper($red . $red . $red);
return $color;
}
function sec2hms($sec, $padHours = FALSE)
{
$hours_min_secs = "";
$hours = INTVAL(INTVAL($sec) / 3600);
$hours_min_secs .= $padHours ? STR_PAD($hours, 2, "0", STR_PAD_LEFT) . ':' : $hours . ':';
$minutes = INTVAL($sec / 60 % 60);
$hours_min_secs .= STR_PAD($minutes, 2, "0", STR_PAD_LEFT) . ':';
$seconds = INTVAL($sec % 60);
$hours_min_secs .= STR_PAD($seconds, 2, "0", STR_PAD_LEFT);
return $hours_min_secs;
}
function show_calendar($startyear, $startmonth, $property_id, $excludestatus = array('draft'), $bookedclass = 'booked', $holdingdiv = true)
{
$start = strtotime("{$startyear}-{$startmonth}-1");
$dom = 1;
//$year, $month, $prepostpack = false, $property_id = false, $excludestatus = array('draft')
$bookings = $this->booking->get_montharray($startyear, $startmonth, true, $property_id, $excludestatus);
if ($holdingdiv) {
echo "<div class='month'>\n";
}
echo "<h4 class='monthname'>";
echo "<span class='name'>" . strftime('%B %Y', $start) . "</span>";
echo "</h4>";
$startingday = (int) strftime('%w', $start);
echo "<ul class='monthdetails'>\n";
// Day of week headings
$wbeg = strtotime('-' . $startingday . ' days', $start);
echo "<li class='weekheadings'>";
echo "<ul class='dow'>";
for ($n = 0; $n < 7; $n++) {
$wday = strtotime('+' . $n . ' days', $wbeg);
echo "<li>" . substr(strftime('%a', $wday), 0, 1) . "</li>";
}
echo "</ul>";
echo "</li>";
echo "<li class='weekrow'>";
echo "<ul>";
for ($n = 0; $n < $startingday; $n++) {
echo "<li class='middle'> </li>";
}
for ($n = $startingday; $n < 7; $n++) {
if ($n != 6) {
$class = "middle";
} else {
$class = '';
}
if (isset($bookings[$startyear . STR_PAD($startmonth, 2, "0", STR_PAD_LEFT) . STR_PAD($dom, 2, "0", STR_PAD_LEFT)])) {
//echo $startyear . STR_PAD($startmonth, 2 , "0", STR_PAD_LEFT) . STR_PAD($dom, 2 , "0", STR_PAD_LEFT);
$class .= " " . $bookedclass;
$yesterday = strtotime('-1 day', strtotime($startyear . '-' . $startmonth . '-' . $dom));
if (!isset($bookings[date("Ymd", $yesterday)])) {
$class .= " startday";
}
$tomorrow = strtotime('+1 day', strtotime($startyear . '-' . $startmonth . '-' . $dom));
if (!isset($bookings[date("Ymd", $tomorrow)])) {
$class .= " endday";
}
}
echo "<li class='{$class}' style='{$style}'>";
echo $dom++;
echo "</li>";
}
echo "</ul>";
echo "</li> <!-- weekrow -->\n";
$dow = 0;
for ($n = $dom; $n <= date('t', $start); $n++) {
if ($dow == 0) {
echo "<li class='weekrow'>\n";
echo "<ul>\n";
}
if ($dow != 6) {
$class = "middle";
} else {
$class = '';
}
if (isset($bookings[$startyear . STR_PAD($startmonth, 2, "0", STR_PAD_LEFT) . STR_PAD($n, 2, "0", STR_PAD_LEFT)])) {
//echo $startyear . STR_PAD($startmonth, 2 , "0", STR_PAD_LEFT) . STR_PAD($dom, 2 , "0", STR_PAD_LEFT);
$class .= " " . $bookedclass;
$yesterday = strtotime('-1 day', strtotime($startyear . '-' . $startmonth . '-' . $n));
if (!isset($bookings[date("Ymd", $yesterday)])) {
$class .= " startday";
}
$tomorrow = strtotime('+1 day', strtotime($startyear . '-' . $startmonth . '-' . $n));
if (!isset($bookings[date("Ymd", $tomorrow)])) {
$class .= " endday";
}
}
$dow++;
echo "<li class='{$class}' style='{$style}'>";
echo $n;
echo "</li>";
if ($dow == 7 && $n != date('t', $start)) {
echo "</ul>\n";
echo "</li> <!-- weekrow -->\n";
$dow = 0;
}
}
// Finish off the last week with blank days
// find the day we are on to co
for ($n = $dow; $n < 7; $n++) {
if ($n != 6) {
echo "<li class='middle'> </li>";
} else {
echo "<li> </li>";
}
}
echo "</ul> <!-- month details -->\n";
if ($holdingdiv) {
echo "</div> <!-- month -->\n";
}
}
// Display warning
?>
<div class='monoHvy'>WARNING!<br />You are about to permanently delete this object.<br/>If this object is linked, the original will not be deleted.</div>
<?php
$l = 0;
if ($k) {
$numrows = $k;
$padout = floor(log10($numrows)) + 1;
if ($padout < 2) {
$padout = 2;
}
echo "\nThe following " . $k . " objects will also be deleted as a result: <br /><br />";
for ($i = 0; $i < $j; $i++) {
$l++;
if ($connectedAll[$i]["dependent"] == TRUE) {
echo "\n" . STR_PAD($l, $padout, "0", STR_PAD_LEFT) . " <a href='" . $dbAdmin . "browse.php" . urlData() . "," . $connectedAll[$i]["id"] . "'>" . strip_tags($connectedAll[$i]["name"]) . "</a><br />";
}
}
}
?>
<br /><br />
<form action="<?php
echo $PHP_SELF . urlData();
?>
" method="post" style="padding: 0px 0px 0px 0px; margin: 0px 0px 0px 0px;">
<input name='action' type='hidden' value='delete' />
<input name='cancel' type='button' value='Cancel' onClick="javascript:history.back();" />
<input name='submit' type='submit' value='Delete Object' />
</form><br />
<?php
} else {
function show_calendar($startyear, $startmonth, $holdingdiv = true)
{
global $filterstartday;
if (!empty($filterstartday)) {
if ($startyear == date('Y', (int) $filterstartday) && $startmonth == date('n', (int) $filterstartday)) {
$selday = date('j', (int) $filterstartday);
} else {
$selday = 0;
}
} else {
$selday = 0;
}
if ($startmonth == date('n') && $startyear == date('Y')) {
$today = date('j');
if ($selday == 0) {
$selday = $today;
}
} else {
$today = 0;
}
$start = strtotime("{$startyear}-{$startmonth}-1");
$dom = 1;
$bookings = $this->booking->get_montharray($startyear, $startmonth, false, false, false);
if ($holdingdiv) {
echo "<div class='month'>\n";
}
echo "<h4 class='monthname'>";
echo "<a href='#prevmonth' class='previousmonth' id='" . date("Y-n", strtotime('-1 month', $start)) . "'> </a>";
echo "<span class='name'>" . strftime('%B %Y', $start) . "</span>";
echo "<a href='#nextmonth' class='nextmonth' id='" . date("Y-n", strtotime('+1 month', $start)) . "'> </a>";
echo "</h4>";
$startingday = (int) strftime('%w', $start);
echo "<ul class='monthdetails'>\n";
// Day of week headings
$wbeg = strtotime('-' . $startingday . ' days', $start);
echo "<li class='weekheadings'>";
echo "<ul class='dow'>";
for ($n = 0; $n < 7; $n++) {
$wday = strtotime('+' . $n . ' days', $wbeg);
echo "<li>" . substr(strftime('%a', $wday), 0, 1) . "</li>";
}
echo "</ul>";
echo "</li>";
echo "<li class='weekrow'>";
echo "<ul>";
for ($n = 0; $n < $startingday; $n++) {
echo "<li class='middle'> </li>";
}
for ($n = $startingday; $n < 7; $n++) {
if ($n != 6) {
$class = "middle";
} else {
$class = '';
}
if ($selday == $dom) {
$class .= " selday";
}
if ($today == $dom) {
$class .= " today";
}
if (isset($bookings[$startyear . STR_PAD($startmonth, 2, "0", STR_PAD_LEFT) . STR_PAD($dom, 2, "0", STR_PAD_LEFT)])) {
//echo $startyear . STR_PAD($startmonth, 2 , "0", STR_PAD_LEFT) . STR_PAD($dom, 2 , "0", STR_PAD_LEFT);
switch ($bookings[$startyear . STR_PAD($startmonth, 2, "0", STR_PAD_LEFT) . STR_PAD($dom, 2, "0", STR_PAD_LEFT)]) {
case 1:
$mark = 1;
break;
case 2:
$mark = 2;
break;
case 3:
$mark = 3;
break;
case 4:
$mark = 4;
break;
default:
$mark = 4;
}
$mark = "<div class='booked booked-" . $mark . "'></div>";
} else {
$mark = '';
}
echo "<li class='{$class}'>";
echo "<a href='" . add_query_arg(array("filterstartday" => strtotime("{$startyear}-{$startmonth}-{$dom}")), remove_query_arg('paged')) . "'>";
echo $dom++;
echo "</a>";
echo $mark;
echo "</li>";
}
echo "</ul>";
echo "</li> <!-- weekrow -->\n";
$dow = 0;
for ($n = $dom; $n <= date('t', $start); $n++) {
if ($dow == 0) {
echo "<li class='weekrow'>\n";
echo "<ul>\n";
}
if ($dow != 6) {
$class = "middle";
} else {
$class = '';
}
if ($selday == $n) {
$class .= " selday";
}
if ($today == $n) {
$class .= " today";
}
if (isset($bookings[$startyear . STR_PAD($startmonth, 2, "0", STR_PAD_LEFT) . STR_PAD($n, 2, "0", STR_PAD_LEFT)])) {
//echo $startyear . STR_PAD($startmonth, 2 , "0", STR_PAD_LEFT) . STR_PAD($dom, 2 , "0", STR_PAD_LEFT);
switch ($bookings[$startyear . STR_PAD($startmonth, 2, "0", STR_PAD_LEFT) . STR_PAD($n, 2, "0", STR_PAD_LEFT)]) {
case 1:
$mark = 1;
break;
case 2:
$mark = 2;
break;
case 3:
$mark = 3;
break;
case 4:
$mark = 4;
break;
default:
$mark = 4;
}
$mark = "<div class='booked booked-" . $mark . "'></div>";
} else {
$mark = '';
}
$dow++;
echo "<li class='{$class}'>";
echo "<a href='" . add_query_arg(array("filterstartday" => strtotime("{$startyear}-{$startmonth}-{$n}")), remove_query_arg('paged')) . "'>";
echo $n;
echo "</a>";
echo $mark;
echo "</li>";
if ($dow == 7 && $n != date('t', $start)) {
echo "</ul>\n";
echo "</li> <!-- weekrow -->\n";
$dow = 0;
}
}
// Finish off the last week with blank days
// find the day we are on to co
for ($n = $dow; $n < 7; $n++) {
if ($n != 6) {
echo "<li class='middle'> </li>";
} else {
echo "<li> </li>";
}
}
echo "</ul> <!-- month details -->\n";
if ($holdingdiv) {
echo "</div> <!-- month -->\n";
}
}
require_once "GLOBAL/head.php";
////////////////////////
// Attached Objects //
////////////////////////
// Get attached objects (if any)
$sql = "SELECT *, objects.id AS objectsId FROM objects, wires WHERE wires.fromid = '" . $objects[$o] . "' AND wires.toid = objects.id AND wires.active = '1' AND objects.active = '1' ORDER BY weight DESC, objects.rank, end DESC, begin DESC, name1, name2, objects.modified DESC, objects.created DESC";
$result = MYSQL_QUERY($sql);
$numrows = MYSQL_NUM_ROWS($result);
$padout = floor(log10($numrows)) + 1;
if ($padout < 2) {
$padout = 2;
}
$i = 1;
$myrow["id"] = $myrow["objectsId"];
while ($myrow = MYSQL_FETCH_ARRAY($result)) {
$name = $myrow["name1"];
if ($myrow["name2"]) {
$name .= " " . $myrow["name2"];
}
if (strlen($name) > 60) {
$name = substr($name, 0, 60) . "...";
}
echo STR_PAD($i++, $padout, "0", STR_PAD_LEFT) . " " . "\n<a href='" . $dbAdmin . "browse.php" . urlData();
if (sizeof($objects)) {
echo ",";
}
echo $myrow["objectsId"] . "'>";
echo strip_tags($name) . "</a><br />";
}
echo "\n<br /><br />\n<a href='add.php" . urlData() . "'>ADD OBJECT...</a> <a href='link.php" . urlData() . "'>LINK ...</a><br />";
require_once "GLOBAL/foot.php";
function RepStandard()
{
// First Generate the query
$sq = $this->RepStandardQuery();
if ($this->display == 'SQL') {
echo "<h1>The Generated SQL</h1>";
hprint_r($sq);
return;
}
// Now execute the query and run the report
if ($this->display == 'CSV') {
echo "<pre>";
echo implode(',', $this->Cols) . "\n";
$res = SQL($sq);
while ($row = pg_fetch_row($res)) {
echo implode(',', $row) . "\n";
}
echo "</pre>";
return;
}
// Pull the info on breaking, sums, etc.
$srep = SQLFC($this->report_id);
$s2 = "SELECT rcl.column_id,rcl.reportlevel,rcl.summact\n FROM reportcollevels rcl\n JOIN reportcolumns rc ON rcl.column_id = rc.column_id\n WHERE rc.report = {$srep}\n ORDER BY rcl.reportlevel,rc.uicolseq";
$breaks = SQL_AllRows($s2);
$abreaks = array();
foreach ($breaks as $break) {
if ($break['summact'] == 'BREAK') {
$abreaks[$break['reportlevel']]['breaks'][$break['column_id']] = '';
} else {
$abreaks[$break['reportlevel']]['data'][$break['column_id']] = array('summact' => $break['summact'], 'val' => 0, 'cnt' => 0);
}
}
// There is always some setup, for either PDF or HTML, so do that
// here.
$this->RepHeader();
// Now execute the query and run the report
$res = SQL($sq);
$firstrow = true;
while ($row = SQL_Fetch_Array($res)) {
if ($firstrow) {
$firstrow = false;
$this->RepStandardBreakLevelsInit($abreaks, $row);
} else {
$this->RepStandardBreakLevels($abreaks, $row);
}
$xpos = 0;
foreach ($this->rows_col as $column_id => $colinfo) {
$disp = substr($row[$column_id], 0, $colinfo['dispsize']);
$disp = STR_PAD($disp, $colinfo['dispsize'], ' ');
$this->PlaceCell($xpos, $disp);
$xpos += 2 + $colinfo['dispsize'];
}
$this->ehFlushLine();
$this->RepStandardRowsToLevels($abreaks, $row);
}
$this->RepStandardBreakLevels($abreaks, $row, true);
// There is always some cleanup, either PDF or HTML
$this->RepFooter();
}
function validate()
{
unset($_SESSION['order']['err']);
$response['success'] = $_SESSION['order']['valid'] = false;
$response['order_prop'] = $response['pay_prop'] = '';
$errors = array();
$uppercase = array('number' => '', 'building' => '', 'gate' => '', 'floor' => '', 'apartment' => '', 'dds' => '');
if (empty($_POST)) {
$response['step'] = 4;
} else {
$response['step'] = $_POST['step'];
foreach ($_POST as $key => $val) {
if (isset($uppercase[$key])) {
$_SESSION['order'][$key] = mb_strtoupper(trim($val), "utf-8");
} else {
$_SESSION['order'][$key] = trim($val);
}
}
if (isset($_POST['invoice'])) {
$_SESSION['order']['invoice'] = 1;
} else {
$_SESSION['order']['invoice'] = 0;
}
}
// Валидация стъпка 1 адрес ************************************************
if (!$_SESSION['order']['district']) {
$errors[] = 'district';
}
if (!($_SESSION['order']['street'] . $_SESSION['order']['building'])) {
$errors[] = 'street';
$errors[] = 'building';
}
if ($_SESSION['order']['street'] && !$_SESSION['order']['number']) {
$errors[] = 'number';
}
if ($_SESSION['order']['building']) {
if (!$_SESSION['order']['gate']) {
$errors[] = 'gate';
}
if (!$_SESSION['order']['apartment']) {
$errors[] = 'apartment';
}
}
if (!empty($errors)) {
$response['step'] = 1;
}
// *************************************************************************
if ($response['step'] > 2) {
// Валидация стъпка 2 дата,час,продължителност **
$dt = $_SESSION['order']['date'];
$tm = $_SESSION['order']['time'];
if (!(strlen($dt) == 10 && checkdate(substr($dt, 3, 2), substr($dt, 0, 2), substr($dt, 6, 4)))) {
$errors[] = 'date';
}
if (!preg_match("/(2[0-3]|[01][0-9]):([0-5][0-9])/", $tm)) {
$errors[] = 'time';
}
if (!$_SESSION['order']['duration']) {
$errors[] = 'duration';
}
if (!$_SESSION['order']['kids_count']) {
$errors[] = 'kids_count';
}
/*else
{
for($i = 0; $i < $_SESSION['order']['kids_count']; $i++)
{
if(!$_SESSION['order']['kid_name[$i]'])
{
$errors[]='kid_name[$i]';
}
if(!$_SESSION['order']['kid_age[$i]'])
{
$errors[]='kid_age[$i]';
}
}
}
*/
if (!empty($errors)) {
$response['step'] = 2;
} else {
$this->calc_price();
}
}
// ***********************************************************************
$total = $_SESSION['order']['price'] + $_SESSION['order']['taxi'];
$response['price'] = (int) $total;
$response['supprice'] = STR_PAD(round($total * 100 - $response['price'] * 100), 2, "0", STR_PAD_LEFT);
if ($response['step'] > 3) {
// Валидация стъпка 3 ***************************
// if (!$_SESSION['order']['first_nanny_id']) {
// $errors[]='select_first_nanny';
// }
// if (!$_SESSION['order']['second_nanny_id']) {
// $errors[]='select_second_nanny';
// }
if (!empty($errors)) {
$response['step'] = 3;
} else {
// Генериране на данни за стъпка 4 ********************************
$_SESSION['order']['valid'] = true;
$adr = "<label class='data-label'>гр.София</label><br/>кв. <label class='data-label'>";
$query = $this->db->get_where('districts', array('dist_id' => $_SESSION['order']['district']));
$adr .= $query->row('dist_name') . "</label><br/>";
foreach ($_SESSION['order'] as $key => $v) {
if (trim($v)) {
$s = "";
switch ($key) {
case 'street':
$l = "бул./ул.";
break;
case 'number':
$l = "No.";
break;
case 'building':
$l = "бл.";
break;
case 'gate':
$l = "вх.";
break;
case 'floor':
$l = "ет.";
break;
case 'apartment':
$l = "ап.";
break;
default:
$l = "";
}
if ($l) {
$adr .= $l . " <label class='data-label'>" . $_SESSION['order'][$key] . " </label>" . $s;
}
}
}
$response['order_prop'] = "<center><h4>Адрес</h4></center><div class='order_prop'>" . $adr;
if ($_SESSION['order']['note']) {
$response['order_prop'] .= "</br></br><label class='control-label'>Допълнително описание</label><br/>\n <textarea class='form-control data-label' style='resize: none;' readonly>" . $_SESSION['order']['note'] . "</textarea>";
}
$response['order_prop'] .= "</div><center><h4>Дата и час</h4></center><div class='prder_prop'>Дата\n <label class='data-label'>" . $_SESSION['order']['date'] . "</label> г. - от <label class='data-label'>" . $_SESSION['order']['time'] . "</label> - до <label class='data-label'>" . date('H:i', strtotime($_SESSION['order']['time'] . "+" . $_SESSION['order']['duration'] . "hours")) . "</label> часа</div>";
$response['pay_prop'] = "<center style='margin-bottom: 20px; background-color: #F8F8F8; padding: 5px;'><h2>\n Цена <label id='cprice'>{$response['price']}</label> <sup><sup id='csupprice'>{$response['supprice']}</sup></sup>\n лв.</h2></center>";
}
// *********************************************************************
}
$cyrillic = $i = 0;
$exceptions = array('date' => '', 'time' => '', 'invoice' => '', 'dds' => '');
foreach ($_SESSION['order'] as $key => $val) {
$i++;
if (!isset($exceptions[$key]) && !preg_match("/(*UTF8)^[А-Яа-я0-9 &.,\"\r\n-]*\$/", $val)) {
if ($i < 10 || $_SESSION['order']['invoice'] && $response['step'] > 2) {
$errors[] = $key;
if (!$cyrillic) {
$cyrillic = $i;
}
}
}
}
if ($cyrillic) {
$errors[] = 'cyrillic';
if ($cyrillic < 10 && $response['step'] > 1) {
$response['step'] = 1;
}
if ($cyrillic > 10 && $response['step'] > 3) {
$response['step'] = 3;
}
}
if (empty($errors)) {
$response['success'] = true;
} else {
$response['errors'] = $errors;
}
if (empty($errors)) {
$response['success'] = true;
} else {
$response['errors'] = $errors;
}
header('Content-Type: application/json');
echo json_encode($response);
}
