function dateRange($page = 1, $from_interval = 7)
{
$to_days = ($page - 1) * $from_interval;
$from_days = $page * $from_interval - 1;
# create a range to fill in rows with no trips
$date_to = date('Y-m-d', strtotime('-' . $to_days . ' days'));
$date_from = date('Y-m-d', strtotime('-' . $from_days . ' days'));
$dates = createDateRangeArray($date_from, $date_to);
rsort($dates);
return $dates;
}
/**
* Nächste Woche funktioniert noch nicht, weil Datum nicht ermittelt wird...
* @param [type] $obj [description]
* @return [type] [description]
*/
function tablesToArr($obj)
{
$arr = array();
$timeframe = explode(" - ", trim($obj->find('> text', 2), " \t\n\r\v()"));
$dates[0] = createDateRangeArray($timeframe[0], $timeframe[1]);
//$dates[1] = createDateRangeArray("14.12.15", "18.12.15");
$tables = $obj->find('table');
if (array_key_exists(0, $tables) && array_key_exists(1, $tables) && array_key_exists(0, $dates) && array_key_exists(1, $dates)) {
return array_merge(tableToArr($tables[0], $dates[0]), tableToArr($tables[1], $dates[1]));
} elseif (array_key_exists(0, $tables) && array_key_exists(0, $dates)) {
return tableToArr($tables[0], $dates[0]);
} else {
return false;
}
}
public function get_sms_data()
{
$where = "";
if (!DashboardCommon::is_su()) {
$where = " AND gsm_number IN( " . $this->get_gsm_number() . " ) {$this->sms_data_limit_clause}\n ORDER BY sms_dt DESC";
}
$dates = createDateRangeArray($this->from, $this->to);
$data_array = array();
foreach ($dates as $date) {
$sql = "SELECT count(*) as total FROM sms ";
$sql .= "WHERE sms_dt LIKE '%" . $date . "%' {$where}";
// echo $sql;
$res = DashboardCommon::db()->Execute($sql);
$data_array[] = array('elapsed' => userdate($date), 'value' => $res->fields['total']);
}
return $data_array;
}
function CollectData($type_for_search, $username, $strDateFrom, $strDateTo)
{
//$strDateFrom = date('Y-m-d', strtotime($year."W".$week_number.'-1'));
//$strDateTo = date('Y-m-d', strtotime($year."W".$week_number.'-7'));
//echo $strDateFrom;
//echo $strDateTo;
// $strDateFrom = date("Y-m-d",strtotime('monday this week'));
// $strDateTo = date("Y-m-d",strtotime("sunday this week"));
// echo 'from';
// echo $strDateFrom;
// echo 'to';
// echo $strDateTo;
$dates_array = createDateRangeArray($strDateFrom, $strDateTo);
$daily_rank_sum_arr = array();
foreach ($dates_array as &$value) {
//echo $value;
if (Get_Logged_users_id()) {
if ($type_for_search != -1) {
$SQL = "SELECT DISTINCT SUM(homeworks.Rank) FROM homeworks,user,uh,solvedhomeworks WHERE homeworks.Type = " . $type_for_search . " AND user.Name = '" . $username . "' AND uh.HWID = homeworks.UID AND uh.USERID = user.UID AND homeworks.Date = '" . $value . "' AND homeworks.UID NOT IN (SELECT solvedhomeworks.HWID FROM solvedhomeworks WHERE solvedhomeworks.USERID = " . Get_Logged_users_id() . ")";
} else {
$SQL = "SELECT DISTINCT SUM(homeworks.Rank) FROM homeworks,user,uh,solvedhomeworks WHERE user.Name = '" . $username . "' AND uh.HWID = homeworks.UID AND uh.USERID = user.UID AND homeworks.Date = '" . $value . "' AND homeworks.UID IN (SELECT solvedhomeworks.HWID FROM solvedhomeworks WHERE solvedhomeworks.USERID = " . Get_Logged_users_id() . ")";
}
} else {
$SQL = "SELECT DISTINCT SUM(homeworks.Rank) FROM homeworks,user,uh WHERE homeworks.Type = " . $type_for_search . " AND user.Name = '" . $username . "' AND uh.HWID = homeworks.UID AND uh.USERID = user.UID AND homeworks.Date = '" . $value . "'";
}
//echo $SQL;
$result = mysql_query($SQL);
$daily_rank_sum = mysql_fetch_array($result);
if ($daily_rank_sum[0] <= 0) {
$daily_rank_sum[0] = 0;
}
array_push($daily_rank_sum_arr, $daily_rank_sum[0]);
}
unset($value);
foreach ($daily_rank_sum_arr as &$value) {
//echo $value;
}
unset($value);
$done_array = array();
for ($i = 0; $i < sizeof($dates_array); $i++) {
array_push($done_array, array($dates_array[$i], $daily_rank_sum_arr[$i] * 10));
}
return $done_array;
// NOW LET'S USE $dates_array and $daily_rank_sum_arr for the graph :D
}
public function get_emails_data()
{
$where = "";
if (!DashboardCommon::is_su()) {
//$where = " AND emails.client_id='".$this->get_unbounce_id()."' AND test_data=0
//ORDER BY email_date DESC";
$where = " AND emails.client_id IN ('" . implode('\',\'', $this->get_unbounce_ids()) . "')\n AND test_data=0 ORDER BY email_date DESC";
}
$dates = createDateRangeArray($this->from, $this->to);
$data_array = array();
foreach ($dates as $date) {
$sql = "SELECT count(*) as total FROM emails ";
$sql .= "WHERE CONVERT_TZ(email_date,'+00:00','+04:00') LIKE '%" . $date . "%' {$where}";
// echo $sql;
$res = DashboardCommon::db()->Execute($sql);
$data_array[] = array('elapsed' => userdate($date), 'value' => $res->fields['total']);
}
return $data_array;
}
public function get_calls_data()
{
$where = "";
if (!DashboardCommon::is_su()) {
$where = " AND gsm_number IN( " . $this->get_gsm_number() . " ) AND test_data=0 {$this->calls_data_limit_clause}";
}
$arr_calls = createDateRangeArray($this->from, $this->to);
$json_array = array();
foreach ($arr_calls as $arr_call) {
$sql = "SELECT count(*) as total FROM calls ";
$sql .= "WHERE call_start LIKE '%" . $arr_call . "%' {$where}";
$res = DashboardCommon::db()->Execute($sql);
$json_array[] = array('elapsed' => userdate($arr_call), 'value' => $res->fields['total']);
}
return $json_array;
header('Content-Type: application/json');
echo json_encode($json_array);
die;
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$date = new \DateTime();
$date->modify('+3 days');
$formatted_date_from = $date->format('Y-m-d');
$date->modify('+6 days');
$formatted_date_to = $date->format('Y-m-d');
$dates = createDateRangeArray(strtotime($formatted_date_from), strtotime($formatted_date_to));
$bases = Base::where('center', 1)->get();
$current_gen = Gen::getCurrentGen();
$shiftSessions = ShiftSession::where('active', 1)->get();
$lastShift = Shift::where('gen_id', $current_gen->id)->orderBy('week', 'desc')->first();
$week = $lastShift ? $lastShift->week : 0;
foreach ($dates as $date) {
foreach ($bases as $base) {
foreach ($shiftSessions as $shiftSession) {
$shift = new Shift();
$shift->gen_id = $current_gen->id;
$shift->base_id = $base->id;
$shift->shift_session_id = $shiftSession->id;
$shift->week = $week + 1;
$shift->date = $date;
$shift->save();
}
}
}
$role_ids = Tab::find(35)->roles->pluck('id')->unique()->toArray();
$roles = Role::whereIn('id', $role_ids)->get();
if ($week == 0) {
$week = 1;
}
foreach ($roles as $role) {
$users = $role->users;
foreach ($users as $user) {
send_mail_regis_shift($user, $week, $current_gen, ['*****@*****.**']);
}
}
$this->info('done');
}
public function getLeadsChartDataClient($period)
{
require_once dirname(__FILE__) . '/Client.php';
$campaigns = Client::get_campaigns();
$first_campaign_start = Client::getFirstCampaignStartDate();
//if(empty($campaigns)) return array();
$union_array = array();
foreach ($campaigns as $campaign) {
$sql = "(SELECT * FROM calls WHERE gsm_number='" . $campaign['gsm_number'] . "'";
if ($campaign['start_date'] != '0000-00-00') {
//if($date < $campaign['start_date']) continue;
$sql .= " AND call_start>='" . $campaign['start_date'] . "'";
}
if ($campaign['end_date'] != '0000-00-00') {
//if($date > $campaign['end_date']) continue;
$sql .= " AND call_end<='" . $campaign['end_date'] . "'";
}
$sql .= ")";
$union_array[] = $sql;
}
$inner_sql = implode(" UNION ", $union_array);
if ($inner_sql == '') {
$inner_sql = "(SELECT * FROM calls WHERE id = NULL)";
}
$client_calls_where = " AND test_data=0 ORDER BY call_start DESC";
$client_email_where = " AND client_id IN ('" . implode('\',\'', $this->get_unbounce_ids()) . "') AND test_data=0\n ORDER BY email_date DESC";
$data = array();
$period_days = array();
$date_filter = "Y-m-d";
if ($period == 'lifetime') {
$period_days = getMonths($this->from, $this->to);
$date_filter = "Y-m";
} elseif ($period == 'last_30_days' || $period == 'last_7_days' || $period == 'yesterday' || $period == 'month' || $period == 'daily' || $period == 'today' || $period == 'this_month' || $period == 'custom' || $period == 'last_month') {
$period_days = createDateRangeArray($this->from, $this->to);
} else {
$period_days = createDateRangeArray($this->from, $this->to);
}
$campaign_start_limit = "";
if ($first_campaign_start != '') {
$campaign_start_limit = "WHERE call_start>='{$first_campaign_start}'";
}
if (!empty($period_days)) {
foreach ($period_days as $date) {
if ($date_filter === 'Y-m-d') {
$date_filtered = $date;
} else {
$date_filtered = date_format($date, "{$date_filter}");
}
$q1 = "SELECT count(*) as total_calls FROM ({$inner_sql}) AS calls WHERE call_start LIKE '%" . $date_filtered . "%' {$client_calls_where} ";
$c_total = 0;
$c_total = DashboardCommon::executeAndReturnSingleColResultAndCache($q1, 'total_calls');
$q2 = "SELECT count(*) as total_emails FROM emails WHERE \n CONVERT_TZ(email_date,'+00:00','+04:00') LIKE '" . $date_filtered . "%' {$client_email_where}";
$e_total = DashboardCommon::executeAndReturnSingleColResultAndCache($q2, 'total_emails');
$sql_leads = "SELECT * , tcalls+temails as total_leads\n FROM\n (SELECT \n /*COUNT(DISTINCT /*DATE_FORMAT(call_start,'%y-%m-%d') ,// gsm_number) as tcalls*/\n COUNT(*) AS tcalls\n FROM ({$inner_sql}) AS calls \n WHERE\n id IN ( SELECT id FROM calls {$campaign_start_limit} GROUP BY callerid HAVING MIN(call_start) ) AND\n call_start LIKE '%" . $date_filtered . "%' {$client_calls_where}\n ) as a , \n (SELECT \n COUNT(*) as temails\n FROM emails \n WHERE\n CONVERT_TZ(email_date,'+00:00','+04:00') LIKE '" . $date_filtered . "%' {$client_email_where}\n ) as b";
//echo $sql_leads; die();
$tot_leads = DashboardCommon::executeAndReturnSingleColResultAndCache($q1, 'total_leads');
$row = array('y' => $date_filtered, 'a' => $c_total, 'b' => $e_total, 'c' => $tot_leads);
$data[] = $row;
}
}
return $data;
}
$(document).ready(function()
{
// Morris.js Graphs
if(typeof Morris != 'undefined')
{
// Area Chart
Morris.Area({
element: 'chart_life_time',
data: [
<?php
$roi_date_from = $res_roi_graph->fields['roi_date'];
$roi_date_to = date('Y-m-d');
$arr_rois = createDateRangeArray($roi_date_from, $roi_date_to);
$i = 0;
foreach ($arr_rois as $arr_roi) {
$i++;
$qry_roi_month = "SELECT SUM(avg_sale_revenue) as total_lifetime FROM roi WHERE roi_date LIKE '%" . $arr_roi . "%'";
$res_roi_month = $db->Execute($qry_roi_month);
$roi_total = $res_roi_month->fields['total_lifetime'];
if ($roi_total == '') {
$roi_total = 0;
}
?>
{ y: '<?php
echo $arr_roi;
?>
', a: <?php
echo $roi_total;
function getbkSortedDates($booking_days)
{
if (strpos($booking_days, ' - ') !== FALSE) {
$booking_days = explode(' - ', $booking_days);
$booking_days = createDateRangeArray($booking_days[0], $booking_days[1]);
}
$days_array = explode(',', $booking_days);
$only_days = array();
foreach ($days_array as $new_day) {
if (!empty($new_day)) {
$new_day = trim($new_day);
if (strpos($new_day, '.') !== false) {
$new_day = explode('.', $new_day);
} else {
$new_day = explode('-', $new_day);
}
$only_days[] = $new_day[2] . '-' . $new_day[1] . '-' . $new_day[0] . ' 00:00:00';
}
}
if (!empty($only_days)) {
sort($only_days);
}
return $only_days;
}
if ($i < count($arr_calls)) {
echo ",";
}
?>
<?php
}
?>
];
var today_data = [
<?php
$calls_date_from = date('Y-m-d');
$calls_date_to = date('Y-m-d');
$arr_calls = createDateRangeArray($calls_date_from, $calls_date_to);
$i = 0;
foreach ($arr_calls as $arr_call) {
$i++;
$qry_calls_month = "SELECT count(*) as month_calls_total FROM calls WHERE call_start LIKE '%" . $arr_call . "%' AND gsm_number IN( " . $client_id . " ) AND test_data=0 {$calls_data_limit_clause}";
$res_calls_month = $db->Execute($qry_calls_month);
?>
{"elapsed": "<?php
echo userdate($arr_call);
?>
", "value": <?php
echo $res_calls_month->fields['month_calls_total'];
?>
} <?php
if ($i < count($arr_calls)) {
$weeks = '';
//-- Start the Date loop
$var = 0;
foreach ($arrEventDates as $e) {
$oDetails = $arrEventsDetail[$e['eventId'] . '-' . $e['eventRepId']];
//Get original event (parent) details
$oDetails['startdate'] = $e['date'];
$oDetails['enddate'] = $e['end'];
if (($oDetails['startdate'] >= $elStartDate || $oDetails['enddate'] >= $elStartDate) && $oDetails['enddate'] <= $elEndDate || $displayType == 'detail' || $elDirectional) {
$oDetails['startdate_fstamp'] = $oDetails['startdate'];
$oDetails['enddate_fstamp'] = $oDetails['enddate'];
$oDetails['detailURL'] = $modx->makeUrl(!empty($ajaxResourceId) && (bool) $modalView === true ? $ajaxResourceId : $did, '', array('detail' => $e['eventId'], 'r' => $e['eventRepId']));
if (strftime('%Y-%m-%d', $e['date']) == strftime('%Y-%m-%d', $e['end'])) {
$events[strftime('%Y-%m-%d', $e['date'])][] = $oDetails;
} else {
$spandates = createDateRangeArray(strftime('%Y-%m-%d', $e['date']), strftime('%Y-%m-%d', $e['end']));
foreach ($spandates as $spD) {
$events[$spD][] = $oDetails;
}
}
// $output.= $e['date']. '<br/>';
}
}
do {
// Week Start date
$iWeek = strtotime('+ ' . $var . ' week', $startMonthCalDate);
$diw = 0;
$days = '';
do {
// Get the week's days
$iDay = strtotime('+ ' . $diw . ' day', $iWeek);
function createDateRangeArray($start, $end)
{
$range = array();
if (is_string($start) === true) {
$start = strtotime($start);
}
if (is_string($end) === true) {
$end = strtotime($end);
}
if ($start > $end) {
return createDateRangeArray($end, $start);
}
do {
$range[] = date('Y-m-d', $start);
$start = strtotime("+ 1 day", $start);
} while ($start <= $end);
return $range;
}
$table_name = "meals_" . $type;
$result_db = mysql_query("SELECT * FROM {$table_name} ORDER BY idx ASC");
$total = 0;
foreach ($c1 as $val) {
$row = mysql_fetch_array($result_db);
$total = $total + $val * $row['price'];
}
return $total;
}
$t1 = get_total_cpw($c1, 'b');
$t2 = get_total_cpw($c2, 'l');
$t3 = get_total_cpw($c3, 's');
$t4 = get_total_cpw($c4, 'd');
$grtotal = $t1 + $t2 + $t3 + $t4;
mysql_query("UPDATE choices SET `cost_per_week_nobasic` = {$grtotal} WHERE s_id = '" . $student_id . "';");
$montharr = createDateRangeArray(date("Y-m-d", mktime(0, 0, 0, $month, 1, $year)), date("Y-m-d", mktime(0, 0, 0, $month + 1, 1, $year)));
$grtotal = 0;
foreach ($montharr as $val) {
$grtotal = $grtotal + get_total_cpd($c1, 'b', $val);
}
foreach ($montharr as $val) {
$grtotal = $grtotal + get_total_cpd($c2, 'l', $val);
}
foreach ($montharr as $val) {
$grtotal = $grtotal + get_total_cpd($c3, 's', $val);
}
foreach ($montharr as $val) {
$grtotal = $grtotal + get_total_cpd($c4, 'd', $val);
}
mysql_query("UPDATE choices SET `cost_month_nobasic` = {$grtotal} WHERE s_id = '" . $student_id . "';");
echo $grtotal;
private function getCommaSeparatedDates($event_dates_start, $event_dates_end)
{
if (isset($event_dates_start['date']) && isset($event_dates_end['date'])) {
//$start_date = date_i18n('Y-m-d', $this->iso_to_ts( $event_dates_start['date'] ) );
//$end_date = date_i18n('Y-m-d', ( $this->iso_to_ts( $event_dates_end['date'] ) - 86400 ) );
$start_date = $this->iso_to_ts($event_dates_start['date']);
$end_date = $this->iso_to_ts($event_dates_end['date']) - 86400;
$range_time = '00:00 - 00:00';
}
if (isset($event_dates_start['dateTime']) && isset($event_dates_end['dateTime'])) {
$start_date = $this->iso_to_ts($event_dates_start['dateTime']);
$end_date = $this->iso_to_ts($event_dates_end['dateTime']);
$range_time = date_i18n('H:i', $start_date) . ' - ' . date_i18n('H:i', $end_date);
//$start_date = date_i18n('Y-m-d', $start_date );
//$end_date = date_i18n('Y-m-d', $end_date );
}
$dates_comma = createDateRangeArray(date_i18n("d.m.Y", $start_date), date_i18n("d.m.Y", $end_date));
//$dates = wpdevbkGetDaysBetween($start_date, $end_date );
//$dates_comma = implode(', ', $dates);
// // Get Times
// $start_time = $this->iso_to_ts( $event_dates[0]['startTime'] );
//
// if ( date_i18n('H:i', $this->iso_to_ts( $event_dates[ (count($event_dates)-1) ]['endTime'] ) ) == '00:00' )
// $end_time = $this->iso_to_ts( $event_dates[ (count($event_dates)-1) ]['endTime'] ) - 86400; // 24 hours - 60*60*24 = 86400
// else
// $end_time = $this->iso_to_ts( $event_dates[ (count($event_dates)-1) ]['endTime'] );
//
//
// $range_time = date_i18n('H:i', $start_time ) . ' - ' . date_i18n('H:i', $end_time );
if ($range_time != '00:00 - 00:00') {
$bktype = $this->getResource();
$range_time = "select-one^rangetime{$bktype}^{$range_time}~";
} else {
$range_time = '';
}
return array($dates_comma, $range_time);
}
if (Input::has('d')) {
$planDate = strtotime(Input::get('d'));
}
$monthStartDate = date('Y-m-01', $planDate);
if (date('w', strtotime($monthStartDate)) != 0) {
$startDate = date('Y-m-d', strtotime('last sunday, 12am', strtotime($monthStartDate)));
} else {
$startDate = $monthStartDate;
}
$monthEndDate = date('Y-m-t', $planDate);
if (date('w', strtotime($monthEndDate)) != 6) {
$endDate = date('Y-m-d', strtotime('next saturday, 12am', strtotime($monthEndDate)));
} else {
$endDate = $monthEndDate;
}
$dates = createDateRangeArray($startDate, $endDate);
$meals = DB::table('meal_calendar')->leftJoin('Recipe', 'meal_calendar.recipe_id', '=', 'Recipe.RecipeId')->whereBetween('meal_date', array($startDate, $endDate))->get();
$plans = array();
foreach ($dates as $date) {
$plans[$date] = array();
foreach ($meals as $meal) {
if (strtotime($meal->meal_date) == strtotime($date)) {
if (isNullOrEmptyString($meal->note)) {
$plans[$date][$meal->id] = "Recipe-" . $meal->RecipeName;
} else {
$plans[$date][$meal->id] = "Note-" . $meal->note;
}
}
}
}
$recipes = Recipe::orderBy('RecipeName')->lists('RecipeName', 'RecipeId');
if ($a == 1) {
$status = $_POST["str4"];
}
}
if ($b == "1") {
$status = $_POST["str4"];
}
}
die;
$q = mysql_query("select * from mpc_leave_application where emp_id ='{$id}' and start_date BETWEEN '{$txt_date2}' AND '{$txt_date1}'");
$aa = mysql_num_rows($q);
$a = mysql_fetch_array($q);
$approved = $a['approved'];
$date1 = $a['start_date'];
$date2 = $a['end_date'];
$datePeriodl = createDateRangeArray($date1, $date2);
if ($aa > 0 && $approved == '1') {
foreach ($datePeriodl as $datePeriodl) {
$date_leave1 = $a['start_date'];
$date_leave2 = $a['end_date'];
$status = $a['leave_type'];
$sql_check_update = "update " . $mysql_table_prefix . "attendence_master set\t\n\t\t\t\tattendance_status='{$status}',\n\t\t\t\tbadli_as ='{$badli_as}',\n\t\t\t\tshift ='{$shift}'\n\t\t\t\twhere emp_id ='{$id}' and date ='{$datePeriodl}'";
$result_check_update = mysql_query($sql_check_update) or die("Query Failed " . mysql_error());
}
}
if (isset($_GET['start'])) {
if ($_GET['start'] == 'All') {
$start = 0;
} else {
$start = $_GET['start'];
}
public function dashboard($domain, $gen_id, $base_id = null)
{
// $current_gen = Gen::getCurrentGen();
if ($this->user->role == 0) {
return $this->responseUnAuthorized('Bạn không có quyền truy cập dữ liệu này');
}
$data = [];
if ($gen_id) {
$current_gen = Gen::find($gen_id);
} else {
return response()->json([message => "gen_id is required"], 400);
}
$data['current_gen'] = $this->genTransformer->transform($current_gen);
if ($base_id == null) {
$zero_paid_num = Register::where('gen_id', $current_gen->id)->where('status', '=', 1)->where('money', '=', 0)->count();
$total_money = Register::where('gen_id', $current_gen->id)->sum('money');
$num = Register::where('gen_id', $current_gen->id)->count();
$paid_number = Register::where('gen_id', $current_gen->id)->where('code', "!=", "")->count();
$uncalled_number = Register::where('gen_id', $current_gen->id)->where('call_status', 0)->groupBy('user_id')->count();
$total_classes = $current_gen->studyclasses->count();
$remain_days = strtotime($current_gen->end_time) - time();
$registers_by_date = Register::select(DB::raw('count(1) as num'))->where('gen_id', $current_gen->id)->groupBy(DB::raw('DATE(created_at)'))->pluck('num')->toArray();
$money_by_date = Register::select(DB::raw('sum(money) as money'))->where('gen_id', $current_gen->id)->groupBy(DB::raw('DATE(paid_time)'))->pluck('money')->toArray();
$registers_by_hour = Register::select(DB::raw('HOUR(created_at) as \'hour\', count(1) as num'))->where('gen_id', $current_gen->id)->groupBy(DB::raw('HOUR(created_at)'))->get();
$registers_hour_array = array();
for ($i = 0; $i < 24; $i++) {
$registers_hour_array[$i] = 0;
}
foreach ($registers_by_hour as $regis) {
$registers_hour_array[$regis->hour] = $regis->num;
}
$data['money_by_date'] = $money_by_date;
$data['zero_paid_num'] = $zero_paid_num;
$data['classes'] = $this->classTransformer->transformCollection($current_gen->studyclasses);
$data['total_money'] = is_numeric($total_money) ? $total_money : 0;
$data['register_number'] = is_numeric($num) ? $num : 0;
$data['paid_number'] = is_numeric($paid_number) ? $paid_number : 0;
$data['uncalled_number'] = is_numeric($uncalled_number) ? $uncalled_number : 0;
$data['total_classes'] = is_numeric($total_classes) ? $total_classes : 0;
$data['remain_days'] = round((is_numeric($remain_days) ? $remain_days : 0) / (24 * 3600), 2);
$data['date_array'] = createDateRangeArray(strtotime($current_gen->start_time), strtotime($current_gen->end_time));
$data['registers_by_date'] = $registers_by_date;
$data['registers_by_hour'] = $registers_hour_array;
} else {
$base = Base::find($base_id);
$classes = $base->classes()->where('gen_id', $current_gen->id);
$registers = Register::where('gen_id', $current_gen->id)->where('gen_id', $current_gen->id)->whereIn('class_id', $classes->pluck('id'));
$zero_paid_num = Register::where('status', '=', 1)->where('money', '=', 0)->whereIn('class_id', $classes->pluck('id'))->count();
$total_money = $registers->sum('money');
$num = $registers->count();
$paid_number = $registers->where('gen_id', $current_gen->id)->where('code', "!=", "")->count();
$uncalled_number = $registers->where('call_status', 0)->groupBy('user_id')->count();
$total_classes = $classes->count();
$remain_days = strtotime($current_gen->end_time) - time();
$classes_id = $classes->pluck("id");
$registers_by_date = Register::select(DB::raw('count(1) as num'))->whereIn("class_id", $classes_id)->where('gen_id', $current_gen->id)->groupBy(DB::raw('DATE(created_at)'))->pluck('num')->toArray();
$registers_by_hour = Register::select(DB::raw('HOUR(created_at) as \'hour\', count(1) as num'))->whereIn("class_id", $classes_id)->where('gen_id', $current_gen->id)->groupBy(DB::raw('HOUR(created_at)'))->get();
$money_by_date = Register::select(DB::raw('sum(money) as money'))->whereIn("class_id", $classes_id)->where('gen_id', $current_gen->id)->groupBy(DB::raw('DATE(paid_time)'))->pluck('money')->toArray();
$registers_hour_array = array();
for ($i = 0; $i < 24; $i++) {
$registers_hour_array[$i] = 0;
}
foreach ($registers_by_hour as $regis) {
$registers_hour_array[$regis->hour] = $regis->num;
}
$data['money_by_date'] = $money_by_date;
$data['zero_paid_num'] = $zero_paid_num;
$data['classes'] = $this->classTransformer->transformCollection($current_gen->studyclasses);
$data['total_money'] = is_numeric($total_money) ? $total_money : 0;
$data['register_number'] = is_numeric($num) ? $num : 0;
$data['paid_number'] = is_numeric($paid_number) ? $paid_number : 0;
$data['uncalled_number'] = is_numeric($uncalled_number) ? $uncalled_number : 0;
$data['total_classes'] = is_numeric($total_classes) ? $total_classes : 0;
$data['remain_days'] = round((is_numeric($remain_days) ? $remain_days : 0) / (24 * 3600), 2);
$data['date_array'] = createDateRangeArray(strtotime($current_gen->start_time), strtotime($current_gen->end_time));
$data['registers_by_date'] = $registers_by_date;
$data['registers_by_hour'] = $registers_hour_array;
}
return response()->json($data, 200);
}
public function save()
{
if ($_POST) {
//get post
$pData = $this->input->post(NULL, TRUE);
//input data
$leaveTypeID = $pData["ddlLeaveType"];
//ประเภทการลา
$leave_because = $pData['txtBecause'];
$leave_start_date = dbDateFormatFromThaiUn543($pData["txtStartDate"]);
//วันที่ลา
$leave_start_time = $pData["txtStartTime"];
//เวลาที่ลา
$leave_end_date = dbDateFormatFromThaiUn543($pData["txtEndDate"]);
//วันสิ้นสุดที่ลา
$leave_end_time = $pData["txtEndTime"];
//เวลาสิ้นสุดของวันที่ลา
//hidden data
$this->user_id = $pData["hdUserID"];
$this->emp_id = $pData["hdEmpID"];
$leaveID = $pData["hdLID"];
$pagetype = $pData['hd_pagetype'];
$pass = $this->leave->checkExistsDate($this->user_id, $leave_start_date, $leave_end_date, $leaveID);
if (!$pass) {
echo swalc("ลาไม่ได้นะ", "วันที่คุณลามีการลาอยู่แล้ว", "error", "history.back();");
} else {
if ($pagetype == 'add') {
$data = array();
$data["L_LTID"] = $leaveTypeID;
$data["L_UserID"] = $this->user_id;
$data["LBecause"] = $leave_because;
$data["LStartDate"] = $leave_start_date;
$data["LStartTime"] = $leave_start_time;
$data["LEndDate"] = $leave_end_date;
$data["LEndTime"] = $leave_end_time;
$data["L_WFID"] = 1;
$data["L_StatusID"] = 1;
$data["LCreatedDate"] = getDateTimeNow();
$data["LLatestUpdate"] = getDateTimeNow();
$leaveID = $this->leave->insertLeave($data);
$uploadPath = $this->config->item('upload_employee') . $this->user_id . '/leave/';
$uploadPath = uploadFileControl("fuDocument", $uploadPath, $leaveID, "leave");
} else {
if ($pagetype == 'edit' || $pagetype == "editdoc") {
//Get old data for insert into log after update new leave data.
$query = $this->leave->getDetailByLeaveID($leaveID);
$query = $query->row_array();
$old_leave_detail = $query;
//ใช้สำหรับส่งไปฟังก์ชั่นส่งเมล์หาหัวหน้า
$old_start_date = dateThaiFormatFromDB($query["LStartDate"]);
$old_start_time = $query["LStartTime"];
$old_end_date = dateThaiFormatFromDB($query["LEndDate"]);
$old_end_time = $query["LEndTime"];
$old_data = array();
$old_data["LL_LID"] = $leaveID;
$old_data["LL_Type"] = "edit";
$old_data["LLDetail"] = "แก้ไขใบลา จากขอลาวันที่ " . $old_start_date . " " . $old_start_time . " จนถึงวันที่ " . $old_end_date . " " . $old_end_time . " แก้ไขเป็นขอลาวันที่ " . $leave_start_date . " " . $leave_start_time . " จนถึงวันที่ " . $leave_end_date . " " . $leave_end_time;
$old_data["LLDate"] = getDateTimeNow();
$old_date["LLBy"] = $this->user_id;
$return_wfid = $old_leave_detail["LReturn_WFID"] == NULL ? 1 : $old_leave_detail["LReturn_WFID"];
if ($pagetype !== "editdoc") {
$data = array();
$data["L_LTID"] = $leaveTypeID;
$data["L_UserID"] = $this->user_id;
$data["LBecause"] = $leave_because;
$data["LStartDate"] = $leave_start_date;
$data["LStartTime"] = $leave_start_time;
$data["LEndDate"] = $leave_end_date;
$data["LEndTime"] = $leave_end_time;
$data["L_WFID"] = $return_wfid;
$data["L_StatusID"] = 1;
$data["LLatestUpdate"] = getDateTimeNow();
$data["LReturn_WFID"] = NULL;
$where = array();
$where["LID"] = $leaveID;
$this->leave->update($data, $where);
} else {
$data = array();
$data["L_WFID"] = $return_wfid;
$data["LLatestUpdate"] = getDateTimeNow();
$data["LReturn_WFID"] = NULL;
$where = array();
$where["LID"] = $leaveID;
$this->leave->update($data, $where);
$old_data["LL_LID"] = $leaveID;
$old_data["LL_Type"] = "editdoc";
$old_data["LLDetail"] = "อัพโหลดเอกสารเพิ่มเติม";
$old_data["LLDate"] = getDateTimeNow();
$old_date["LLBy"] = $this->user_id;
}
$uploadPath = $this->config->item('upload_employee') . $this->user_id . '/leave/';
$uploadPath = uploadFileControl("fuDocument", $uploadPath, $leaveID, "editleave");
//update log for change data
$this->load->model('Leavelog_model', 'leavelog');
$this->leavelog->insert($old_data);
}
}
/***********************************************************************************
* คำนวณจำนวนวันลาแล้วบันทึกลง T_LeaveTimeDetail จะเก็บเกี่ยวกับจำนวนชั่วโมงในการลาของแต่ละวัน
* โดยคำนวณจาก T_Config ที่เก็บเวลาเริ่มทำงาน + เวลาสิ้นสุดการทำงาน โดยหักลบด้วย เวลาพัก
* จะได้ชั่วโมงทำงานที่แท้จริง จากนั้นเอามาหักลบจากที่ลา เช่นลาตอน 4 โมงเย็น เลิกงาน 6 โมงเย็น
* ก็บันทึกลงไปใน T_LeaveTimeDetail ว่า ลา 2 ชั่วโมงของวันที่ 23/03/2558
* จากนั้นเวลาเอาไปคิดว่าลาไปจำนวนกี่วันแล้วก็ใช้สูตร จำนวนชั่วโมงที่ลา / เวลาทำงาน
* แล้วบันทึกลงไปใน T_LeaveQuota
***********************************************************************************/
/* This sector is find total work hour of day */
$query = $this->configuration->getWorkTime();
$workTimeStart = $query["workTimeStart"];
//เวลาเริ่มทำงาน
$workTimeEnd = $query["workTimeEnd"];
//เวลาเลิกงาน
$query = $this->configuration->getBreakTime();
$breakTimeStart = $query["breakTimeStart"];
//เวลาเริ่มพัก
$breakTimeEnd = $query["breakTimeEnd"];
//เวลาเลิกพัก
$workHour = timeDiff($workTimeStart, $workTimeEnd);
$breakHour = timeDiff($breakTimeStart, $breakTimeEnd);
$totalWorkHour = $workHour - $breakHour;
//Normal about time is 8 hours.
/**
* วนลูปเพื่อเช็คแต่ละวันใช้ลาไปวันละกี่ชั่วโมง
* 1. ใช้ function get ว่าระหว่างวันที่เริ่ม กับ วันที่สิ้นสุดลามีวันอะไรบ้างลงใน array
* 2. หาจำนวนชั่วโมงของวันที่ลาว่าลากี่ชั่วโมง
* 3. บันทึกลง T_LeaveTimeDetail
*/
$dateLeave = createDateRangeArray($leave_start_date, $leave_end_date);
$totalLeaveHour = 0;
$numHour = 0;
$dataTime = array();
$dataTime["LTD_LID"] = $leaveID;
$dataTime["LTDDate"] = "";
$dataTime["LTDHour"] = "";
$dataWorkDate = $this->configuration->getWorkDate();
$workDayStart = $dataWorkDate["workDateStart"];
$workDayEnd = $dataWorkDate["workDateEnd"];
//ต้องคำนวณด้วยว่าเป็นวันทำงานหรือเปล่า อย่างเช่นตอนนี้มีการผิดพลาดเกิดขึ้นเมื่อลา
//วันศุกร์ - วันจันทร์ ตย. วันศุกร์ลา 9:00 - วันจันทร์ 9:00 จะถูกนับเป็น 4 วัน
//ต้องเอาวันที่หยุดใน config มาหักลบด้วย ถึงจะได้ตัวเลขที่แท้จริง
for ($i = 0; $i < count($dateLeave); $i++) {
if (checkWeekDay($dateLeave[$i]) >= $workDayStart && checkWeekDay($dateLeave[$i]) <= $workDayEnd) {
//เช็คว่าวันที่ลาอยู่ระหว่างวันทำงานหรือไม่
if (count($dateLeave) == 1) {
$numHour = timeDiff($leave_start_time, $leave_end_time);
if ($numHour > 6) {
$numHour = $numHour - $breakHour;
}
$totalLeaveHour = $totalLeaveHour + $numHour;
} else {
if ($dateLeave[$i] == $leave_start_date) {
$numHour = timeDiff($leave_start_time, $workTimeEnd);
if ($numHour > 6) {
$numHour = $numHour - $breakHour;
}
//ถ้าเป็นวันเริ่มต้นให้เอาเวลาของวันเริ่มมาคำนวณหาจำนวนชั่วโมงการลา
$totalLeaveHour = $totalLeaveHour + $numHour;
} else {
$numHour = $totalWorkHour;
//ถ้าเป็นวันที่อยู่ระหว่างวันเริ่มกับวันสิ้นสุดให้เอาจำนวนชั่วโมงที่ทำงานมาเลย
$totalLeaveHour = $totalLeaveHour + $totalWorkHour;
}
if ($dateLeave[$i] == $leave_end_date) {
$numHour = timeDiff($workTimeStart, $leave_end_time);
//ถ้าเป็นวันสิ้นสุดการลาให้เอาเวลาของวันสิ้นสุดมาคำนวณหาจำนวนชั่วโมงการลา
$totalLeaveHour = $totalLeaveHour + $numHour;
}
}
$dataTime["LTDDate"] = $dateLeave[$i];
$dataTime["LTDHour"] = $numHour;
//case edit delete old leave time detail
if ($pagetype == 'edit') {
$this->leavetimedetail->deleteByLeaveID($leaveID);
}
$this->leavetimedetail->insertTime($dataTime);
}
}
/**
* เอาจำนวนชั่วโมงทั้งหมด มาหารจำนวนชั่วโมงที่ต้องทำงานแต่ละวัน หาว่าใช้ไปกี่วัน
* แล้วบันทึกลงไปที่ T_LeaveQuota
**/
//change to calculate all leave request to get quota
$this->leavequota->calculate_quota($this->user_id, $leaveTypeID);
//ใช้การคำนวณร่วมกับ leavetimedetail
//หลังจากบันทึกทุกอย่างเสร็จแล้ว ส่ง อีเมล์บอกหัวหน้างานของตัวเองว่ามีการขอลา
//insert log
log_leave("send leave request", $leaveID, "ส่งใบลา", $this->user_id);
//run workflow system
$this->load->library("WorkflowSystem");
$process = '';
if ($pagetype == 'add') {
$this->workflowsystem->set_require_data($leaveID, "leave", "request");
$process = $this->workflowsystem->run();
//$process = $this->send_mail_to_leave_headman($leaveID,1);
} else {
if ($pagetype == 'edit') {
$this->workflowsystem->set_require_data($leaveID, "leave", "edit request");
$process = $this->workflowsystem->run();
//$process = $this->send_mail_to_leave_headman($leaveID,1,'edit',$old_leave_detail);
} else {
if ($pagetype == 'editdoc') {
$this->workflowsystem->set_require_data($leaveID, "leave", "edit document");
$process = $this->workflowsystem->run();
//$process = $this->send_mail_to_leave_headman($leaveID,1,'edit',$old_leave_detail);
}
}
}
if ($process != 'success') {
echo swalc('ผิดพลาด!!', 'ระบบบันทึกการลาของคุณแล้ว แต่ไม่สามารถส่งอีเมล์ถึงหัวหน้าของคุณได้<br/>' + $this->phpmailer->ErrorInfo, 'error', "window.location.href = '" . site_url("Leave") . "'");
} else {
echo swalc('สำเร็จ!!', 'บันทึกการลาของคุณพร้อมส่งอีเมล์ให้หัวหน้าเรียบร้อยแล้ว', 'success', "window.location.href = '" . site_url("Leave") . "'");
}
}
}
}
public function get_dashboard_data(Request $request)
{
$base_id = $request->base_id;
$current_gen = Gen::getCurrentGen();
$gen_id = $request->gen_id;
if ($gen_id) {
$current_gen = Gen::find($gen_id);
}
$this->data['current_gen'] = $current_gen;
if ($base_id == null) {
$zero_paid_num = Register::where('gen_id', $current_gen->id)->where('status', '=', 1)->where('money', '=', 0)->count();
$total_money = Register::where('gen_id', $current_gen->id)->sum('money');
$num = Register::where('gen_id', $current_gen->id)->count();
$paid_number = Register::where('gen_id', $current_gen->id)->where('code', "!=", "")->count();
$uncalled_number = Register::where('gen_id', $current_gen->id)->where('call_status', 0)->groupBy('user_id')->count();
$total_classes = $current_gen->studyclasses->count();
$remain_days = strtotime($current_gen->end_time) - time();
$registers_by_date = Register::select(DB::raw('count(1) as num'))->where('gen_id', $current_gen->id)->groupBy(DB::raw('DATE(created_at)'))->pluck('num')->toArray();
$money_by_date = Register::select(DB::raw('sum(money) as money'))->where('gen_id', $current_gen->id)->groupBy(DB::raw('DATE(paid_time)'))->pluck('money')->toArray();
$registers_by_hour = Register::select(DB::raw('HOUR(created_at) as \'hour\', count(1) as num'))->where('gen_id', $current_gen->id)->groupBy(DB::raw('HOUR(created_at)'))->get();
$orders_by_hour = Order::select(DB::raw('DATE(created_at) as date,count(1) as num'))->groupBy(DB::raw('DATE(created_at)'))->get();
$e = date('Y-m-d', time());
$s = date('Y-m-d', time() - 24 * 60 * 60 * 7 * 4);
$month_ago = createDateRangeArray(strtotime($s), strtotime($e));
$orders = [];
foreach ($orders_by_hour as $i) {
$orders[$i->date] = $i->num;
}
$return_orders = [];
foreach ($month_ago as $day) {
if (array_key_exists($day, $orders)) {
$return_orders[$day] = $orders[$day];
} else {
$return_orders[$day] = 0;
}
}
$registers_hour_array = array();
for ($i = 0; $i < 24; $i++) {
$registers_hour_array[$i] = 0;
}
foreach ($registers_by_hour as $regis) {
$registers_hour_array[$regis->hour] = $regis->num;
}
$this->data['money_by_date'] = json_encode($money_by_date);
$this->data['zero_paid_num'] = $zero_paid_num;
$this->data['classes'] = $current_gen->studyclasses;
$this->data['total_money'] = is_numeric($total_money) ? $total_money : 0;
$this->data['register_number'] = is_numeric($num) ? $num : 0;
$this->data['paid_number'] = is_numeric($paid_number) ? $paid_number : 0;
$this->data['uncalled_number'] = is_numeric($uncalled_number) ? $uncalled_number : 0;
$this->data['total_classes'] = is_numeric($total_classes) ? $total_classes : 0;
$this->data['remain_days'] = round((is_numeric($remain_days) ? $remain_days : 0) / (24 * 3600), 2);
$this->data['date_array'] = json_encode(createDateRangeArray(strtotime($current_gen->start_time), strtotime($current_gen->end_time)));
$this->data['registers_by_date'] = json_encode($registers_by_date);
$this->data['registers_by_hour'] = json_encode($registers_hour_array);
$this->data['orders_by_hour'] = json_encode(array_values($return_orders));
$this->data['month_ago'] = json_encode($month_ago);
} else {
$base = Base::find($base_id);
$classes = $base->classes()->where('gen_id', $current_gen->id);
$registers = Register::where('gen_id', $current_gen->id)->where('gen_id', $current_gen->id)->whereIn('class_id', $classes->pluck('id'));
$zero_paid_num = Register::where('status', '=', 1)->where('money', '=', 0)->whereIn('class_id', $classes->pluck('id'))->count();
$total_money = $registers->sum('money');
$num = $registers->count();
$paid_number = $registers->where('gen_id', $current_gen->id)->where('code', "!=", "")->count();
$uncalled_number = $registers->where('call_status', 0)->groupBy('user_id')->count();
$total_classes = $classes->count();
$remain_days = strtotime($current_gen->end_time) - time();
$classes_id = $classes->pluck("id");
$registers_by_date = Register::select(DB::raw('count(1) as num'))->whereIn("class_id", $classes_id)->where('gen_id', $current_gen->id)->groupBy(DB::raw('DATE(created_at)'))->pluck('num')->toArray();
$registers_by_hour = Register::select(DB::raw('HOUR(created_at) as \'hour\', count(1) as num'))->whereIn("class_id", $classes_id)->where('gen_id', $current_gen->id)->groupBy(DB::raw('HOUR(created_at)'))->get();
$money_by_date = Register::select(DB::raw('sum(money) as money'))->whereIn("class_id", $classes_id)->where('gen_id', $current_gen->id)->groupBy(DB::raw('DATE(paid_time)'))->pluck('money')->toArray();
$registers_hour_array = array();
for ($i = 0; $i < 24; $i++) {
$registers_hour_array[$i] = 0;
}
foreach ($registers_by_hour as $regis) {
$registers_hour_array[$regis->hour] = $regis->num;
}
$this->data['money_by_date'] = json_encode($money_by_date);
$this->data['zero_paid_num'] = $zero_paid_num;
$this->data['classes'] = $classes->get();
$this->data['total_money'] = is_numeric($total_money) ? $total_money : 0;
$this->data['register_number'] = is_numeric($num) ? $num : 0;
$this->data['paid_number'] = is_numeric($paid_number) ? $paid_number : 0;
$this->data['uncalled_number'] = is_numeric($uncalled_number) ? $uncalled_number : 0;
$this->data['total_classes'] = is_numeric($total_classes) ? $total_classes : 0;
$this->data['remain_days'] = round((is_numeric($remain_days) ? $remain_days : 0) / (24 * 3600), 2);
$this->data['date_array'] = json_encode(createDateRangeArray(strtotime($current_gen->start_time), strtotime($current_gen->end_time)));
$this->data['registers_by_date'] = json_encode($registers_by_date);
$this->data['registers_by_hour'] = json_encode($registers_hour_array);
}
return view('components.dashboard_data', $this->data);
}
include "inc/function.php";
$id = "";
$txt_date1 = $_GET["id"];
$id = $_GET["str"];
$txt_date2 = $_GET["sdate"];
$status = $_POST["str4"];
$badli_as = $_POST["str5"];
$type = $_POST["str6"];
$shift = $_GET["str7"];
////////////////////// Markin attendence //////////////
$ip = $_SERVER['REMOTE_ADDR'];
$good_work = "";
//
$txt_date1 = str_replace("/", "-", $txt_date1);
$txt_date2 = str_replace("/", "-", $txt_date2);
$datePeriod = createDateRangeArray($txt_date1, $txt_date2);
foreach ($datePeriod as $datePeriod) {
//
$sql_check = "update " . $mysql_table_prefix . "attendence_master set\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tattendance_status='{$status}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tbadli_as ='{$badli_as}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tshift ='{$shift}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tgood_work ='{$good_work}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tInsertBy ='{$id}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tInsertDate =now(),\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tIpAddress ='{$ip}'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\twhere emp_id ='{$id}' and date ='{$datePeriod}'";
$result_check = mysql_query($sql_check) or die("Query Failed " . mysql_error());
}
?>
<?php
if (isset($_GET['start'])) {
if ($_GET['start'] == 'All') {
$start = 0;
} else {
$start = $_GET['start'];
}
} else {
}
?>
],
xkey: 'y',
ykeys: ['a'],
labels: ['ROI']
});
Morris.Area({
element: 'chart_today_data',
data: [
<?php
$emails_date_from = date('Y-m-d');
$emails_date_to = date('Y-m-d');
$arr_emails = createDateRangeArray($emails_date_from, $emails_date_to);
$i = 0;
foreach ($arr_emails as $arr_email) {
$i++;
$qry_roi_month = "SELECT SUM(avg_sale_revenue) as total_lifetime FROM roi WHERE roi_date LIKE '%" . $arr_email . "%' AND client_id='" . $client_id . "'";
$res_roi_month = $db->Execute($qry_roi_month);
$roi_total = $res_roi_month->fields['total_lifetime'];
if ($roi_total == '') {
$roi_total = 0;
}
?>
{ y: '<?php
echo $arr_email;
?>
', a: <?php
echo $roi_total;
function wpdev_bk_insert_new_booking()
{
global $wpdb;
make_bk_action('check_multiuser_params_for_client_side', $_POST["bktype"]);
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// Define init variables
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$dates = $_POST["dates"];
$bktype = intval($_POST["bktype"]);
if ($bktype == 0) {
// Error
?>
<script type="text/javascript"> document.getElementById('submiting<?php
echo $bktype;
?>
').innerHTML = '<div style="height:20px;width:100%;text-align:center;margin:15px auto;"><?php
bk_error('Error od saving data into DB. Unknown booking resource.', __FILE__, __LINE__);
?>
</div>'; </script> <?php
die;
}
$formdata = $_POST["form"];
$formdata = escape_any_xss($formdata);
$is_send_emeils = 1;
if (isset($_POST["is_send_emeils"])) {
$is_send_emeils = $_POST["is_send_emeils"];
}
$my_booking_id = 0;
$my_booking_hash = '';
if (function_exists('get_booking_title')) {
$bk_title = get_booking_title($bktype);
} else {
$bk_title = '';
}
if (isset($_POST['my_booking_hash'])) {
$my_booking_hash = $_POST['my_booking_hash'];
if ($my_booking_hash != '') {
$my_booking_id_type = false;
$my_booking_id_type = apply_bk_filter('wpdev_booking_get_hash_to_id', false, $my_booking_hash);
if ($my_booking_id_type !== false) {
$my_booking_id = $my_booking_id_type[0];
$bktype = $my_booking_id_type[1];
}
}
}
if (strpos($dates, ' - ') !== FALSE) {
$dates = explode(' - ', $dates);
$dates = createDateRangeArray($dates[0], $dates[1]);
}
//debuge($_POST);
/// CAPTCHA CHECKING //////////////////////////////////////////////////////////////////////////////////////
$the_answer_from_respondent = $_POST['captcha_user_input'];
$prefix = $_POST['captcha_chalange'];
if (!($the_answer_from_respondent == '' && $prefix == '')) {
$captcha_instance = new wpdevReallySimpleCaptcha();
$correct = $captcha_instance->check($prefix, $the_answer_from_respondent);
if (!$correct) {
$word = $captcha_instance->generate_random_word();
$prefix = mt_rand();
$captcha_instance->generate_image($prefix, $word);
$filename = $prefix . '.png';
$captcha_url = WPDEV_BK_PLUGIN_URL . '/js/captcha/tmp/' . $filename;
$ref = substr($filename, 0, strrpos($filename, '.'));
?>
<script type="text/javascript">
document.getElementById('captcha_input<?php
echo $bktype;
?>
').value = '';
// chnage img
document.getElementById('captcha_img<?php
echo $bktype;
?>
').src = '<?php
echo $captcha_url;
?>
';
document.getElementById('wpdev_captcha_challenge_<?php
echo $bktype;
?>
').value = '<?php
echo $ref;
?>
';
document.getElementById('captcha_msg<?php
echo $bktype;
?>
').innerHTML =
'<span class="alert" style="padding: 5px 5px 4px;vertical-align: middle;text-align:center;margin:5px;"><?php
echo __('The code you entered is incorrect', 'wpdev-booking');
?>
</span>';
document.getElementById('submiting<?php
echo $bktype;
?>
').innerHTML ='';
jQuery('#captcha_input<?php
echo $bktype;
?>
')
.fadeOut( 350 ).fadeIn( 300 )
.fadeOut( 350 ).fadeIn( 400 )
.animate( {opacity: 1}, 4000 )
; // mark red border
jQuery("span.wpdev-help-message span.alert")
.fadeIn( 1 )
//.css( {'color' : 'red'} )
.animate( {opacity: 1}, 10000 )
.fadeOut( 2000 ); // hide message
document.getElementById('captcha_input<?php
echo $bktype;
?>
').focus(); // make focus to elemnt
jQuery('#booking_form_div<?php
echo $bktype;
?>
input[type=button]').prop("disabled", false);
</script> <?php
die;
}
}
//////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$my_modification_date = "'" . date_i18n('Y-m-d H:i:s') . "'";
// Localize booking modification date
//$my_modification_date = 'NOW()'; // Server value modification date
if ($my_booking_id > 0) {
// Edit exist booking
if (strpos($_SERVER['HTTP_REFERER'], 'wp-admin/admin.php?') !== false) {
?>
<script type="text/javascript">
document.getElementById('ajax_working').innerHTML =
'<div class="updated ajax_message" id="ajax_message">\n\
<div style="float:left;"><?php
echo __('Updating...', 'wpdev-booking');
?>
</div> \n\
<div class="wpbc_spin_loader">\n\
<img src="'+wpdev_bk_plugin_url+'/img/ajax-loader.gif">\n\
</div>\n\
</div>';
</script> <?php
}
$update_sql = "UPDATE {$wpdb->prefix}booking AS bk SET bk.form='{$formdata}', bk.booking_type={$bktype} , bk.modification_date={$my_modification_date} WHERE bk.booking_id={$my_booking_id};";
if (false === $wpdb->query($update_sql)) {
?>
<script type="text/javascript"> document.getElementById('submiting<?php
echo $bktype;
?>
').innerHTML = '<div style="height:20px;width:100%;text-align:center;margin:15px auto;"><?php
bk_error('Error during updating exist booking in DB', __FILE__, __LINE__);
?>
</div>'; </script> <?php
die;
}
// Check if dates already aproved or no
$slct_sql = "SELECT approved FROM {$wpdb->prefix}bookingdates WHERE booking_id IN ({$my_booking_id}) LIMIT 0,1";
$slct_sql_results = $wpdb->get_results($slct_sql);
if (count($slct_sql_results) > 0) {
$is_approved_dates = $slct_sql_results[0]->approved;
}
$delete_sql = "DELETE FROM {$wpdb->prefix}bookingdates WHERE booking_id IN ({$my_booking_id})";
if (false === $wpdb->query($delete_sql)) {
?>
<script type="text/javascript"> document.getElementById('submiting<?php
echo $bktype;
?>
').innerHTML = '<div style="height:20px;width:100%;text-align:center;margin:15px auto;"><?php
bk_error('Error during updating exist booking for deleting dates in DB', __FILE__, __LINE__);
?>
</div>'; </script> <?php
die;
}
$booking_id = (int) $my_booking_id;
//Get ID of reservation
} else {
// Add new booking
$sql_insertion = "INSERT INTO {$wpdb->prefix}booking (form, booking_type, modification_date) VALUES ('{$formdata}', {$bktype}, {$my_modification_date} )";
if (false === $wpdb->query($sql_insertion)) {
?>
<script type="text/javascript"> document.getElementById('submiting<?php
echo $bktype;
?>
').innerHTML = '<div style="height:20px;width:100%;text-align:center;margin:15px auto;"><?php
bk_error('Error during inserting into DB', __FILE__, __LINE__);
?>
</div>'; </script> <?php
die;
}
// Make insertion into BOOKINGDATES
$booking_id = (int) $wpdb->insert_id;
//Get ID of reservation
$is_approved_dates = '0';
$auto_approve_new_bookings_is_active = get_bk_option('booking_auto_approve_new_bookings_is_active');
if (trim($auto_approve_new_bookings_is_active) == 'On') {
$is_approved_dates = '1';
}
}
$my_dates = explode(",", $dates);
$i = 0;
foreach ($my_dates as $md) {
$my_dates[$i] = trim($my_dates[$i]);
$i++;
}
$start_end_time = get_times_from_bk_form($formdata, $my_dates, $bktype);
$start_time = $start_end_time[0];
$end_time = $start_end_time[1];
$my_dates = $start_end_time[2];
make_bk_action('wpdev_booking_post_inserted', $booking_id, $bktype, str_replace('|', ',', $dates), array($start_time, $end_time));
$my_cost = apply_bk_filter('get_booking_cost_from_db', '', $booking_id);
$i = 0;
foreach ($my_dates as $md) {
// Set in dates in such format: yyyy.mm.dd
if ($md != '') {
$md = explode('.', $md);
$my_dates[$i] = $md[2] . '.' . (intval($md[1]) < 10 ? '0' . intval($md[1]) : $md[1]) . '.' . (intval($md[0]) < 10 ? '0' . intval($md[0]) : $md[0]);
} else {
unset($my_dates[$i]);
}
// If some dates is empty so remove it // This situation can be if using several bk calendars and some calendars is not checked
$i++;
}
//debuge($my_dates);
sort($my_dates);
// Sort dates
//debuge($my_dates);
$my_dates4emeil = '';
$i = 0;
$insert = '';
$my_date_previos = '';
foreach ($my_dates as $my_date) {
$i++;
// Loop through all dates
if (strpos($my_date, '.') !== false) {
if (get_bk_option('booking_recurrent_time') !== 'On') {
$my_date = explode('.', $my_date);
if ($i == 1) {
if (!isset($start_time[0]) || empty($start_time[0])) {
$start_time[0] = '00';
}
if (!isset($start_time[1]) || empty($start_time[1])) {
$start_time[1] = '00';
}
if ($start_time[0] == '00' && $start_time[1] == '00') {
$start_time[2] = '00';
}
$date = sprintf("%04d-%02d-%02d %02d:%02d:%02d", $my_date[0], $my_date[1], $my_date[2], $start_time[0], $start_time[1], $start_time[2]);
} elseif ($i == count($my_dates)) {
if (!isset($end_time[0]) || empty($end_time[0])) {
$end_time[0] = '00';
}
if (!isset($end_time[1]) || empty($end_time[1])) {
$end_time[1] = '00';
}
if ($end_time[0] == '00' && $end_time[1] == '00') {
$end_time[2] = '00';
}
$date = sprintf("%04d-%02d-%02d %02d:%02d:%02d", $my_date[0], $my_date[1], $my_date[2], $end_time[0], $end_time[1], $end_time[2]);
} else {
$date = sprintf("%04d-%02d-%02d %02d:%02d:%02d", $my_date[0], $my_date[1], $my_date[2], '00', '00', '00');
}
$my_dates4emeil .= $date . ',';
if (!empty($insert)) {
$insert .= ', ';
}
$insert .= "('{$booking_id}', '{$date}', '{$is_approved_dates}' )";
} else {
if ($my_date_previos == $my_date) {
continue;
}
// escape for single day selections.
$my_date_previos = $my_date;
$my_date = explode('.', $my_date);
$date = sprintf("%04d-%02d-%02d %02d:%02d:%02d", $my_date[0], $my_date[1], $my_date[2], $start_time[0], $start_time[1], $start_time[2]);
$my_dates4emeil .= $date . ',';
if (!empty($insert)) {
$insert .= ', ';
}
$insert .= "('{$booking_id}', '{$date}', '{$is_approved_dates}' )";
$date = sprintf("%04d-%02d-%02d %02d:%02d:%02d", $my_date[0], $my_date[1], $my_date[2], $end_time[0], $end_time[1], $end_time[2]);
$my_dates4emeil .= $date . ',';
if (!empty($insert)) {
$insert .= ', ';
}
$insert .= "('{$booking_id}', '{$date}', '{$is_approved_dates}' )";
}
}
}
$my_dates4emeil = substr($my_dates4emeil, 0, -1);
$my_dates4emeil_check_in_out = explode(',', $my_dates4emeil);
$my_check_in_date = change_date_format($my_dates4emeil_check_in_out[0]);
$my_check_out_date = change_date_format($my_dates4emeil_check_in_out[count($my_dates4emeil_check_in_out) - 1]);
// Save the sort date
$sql_sort_date = "UPDATE {$wpdb->prefix}booking SET sort_date = '" . $my_dates4emeil_check_in_out[0] . "' WHERE booking_id = " . $booking_id . " ";
$wpdb->query($sql_sort_date);
if (!empty($insert)) {
if (false === $wpdb->query("INSERT INTO {$wpdb->prefix}bookingdates (booking_id, booking_date, approved) VALUES " . $insert)) {
?>
<script type="text/javascript"> document.getElementById('submiting<?php
echo $bktype;
?>
').innerHTML = '<div style="height:20px;width:100%;text-align:center;margin:15px auto;"><?php
bk_error('Error during inserting into BD - Dates', __FILE__, __LINE__);
?>
</div>'; </script> <?php
die;
}
}
if ($my_booking_id > 0) {
// For editing exist booking
if ($is_send_emeils != 0) {
sendModificationEmails($booking_id, $bktype, $formdata);
}
if (strpos($_SERVER['HTTP_REFERER'], 'wp-admin/admin.php?') === false) {
do_action('wpdev_new_booking', $booking_id, $bktype, str_replace('|', ',', $dates), array($start_time, $end_time), $formdata);
}
?>
<script type="text/javascript">
<?php
if (strpos($_SERVER['HTTP_REFERER'], 'wp-admin/admin.php?') === false) {
?>
setReservedSelectedDates('<?php
echo $bktype;
?>
');
<?php
} else {
?>
document.getElementById('ajax_message').innerHTML = '<?php
echo __('Updated successfully', 'wpdev-booking');
?>
';
jQuery('#ajax_message').fadeOut(1000);
document.getElementById('submiting<?php
echo $bktype;
?>
').innerHTML = '<div style="height:20px;width:100%;text-align:center;margin:15px auto;"><?php
echo __('Updated successfully', 'wpdev-booking');
?>
</div>';
if ( jQuery('#wpdev_http_referer').length > 0 ) {
location.href=jQuery('#wpdev_http_referer').val();
} else location.href='admin.php?page=<?php
echo WPDEV_BK_PLUGIN_DIRNAME . '/' . WPDEV_BK_PLUGIN_FILENAME;
?>
wpdev-booking&view_mode=vm_listing&tab=actions&wh_booking_id=<?php
echo $my_booking_id;
?>
';
<?php
}
?>
</script> <?php
} else {
// For inserting NEW booking
if (count($my_dates) > 0) {
if ($is_send_emeils != 0) {
sendNewBookingEmails($booking_id, $bktype, $formdata);
}
}
do_action('wpdev_new_booking', $booking_id, $bktype, str_replace('|', ',', $dates), array($start_time, $end_time), $formdata);
/*
// Start Mail Chimp Customization
$booking_form_show = get_form_content ($formdata , $bktype );
if ( ( isset ($booking_form_show['subscribe_me'] )) && ( $booking_form_show['subscribe_me'] == 'yes') ) {
if (file_exists(WPDEV_BK_PLUGIN_DIR. '/lib/MailChimp.class.php')) { // Include MailChimp class (You can download it from here https://github.com/drewm/mailchimp-api/ )
require_once(WPDEV_BK_PLUGIN_DIR. '/lib/MailChimp.class.php' );
$MailChimp = new MailChimp('key-my'); // You are need to specify here YOUR KEY !!!!
$result = $MailChimp->call('lists/subscribe', array(
'id' => 'id' . $booking_id ,
'email' => array('email'=>$booking_form_show['email']),
'merge_vars' => array('FNAME'=>$booking_form_show['name'], 'LNAME'=>$booking_form_show['secondname']),
'double_optin' => false,
'update_existing' => true,
'replace_interests' => false,
'send_welcome' => false,
));
// print_r($result);
}
} // End Mail Chimp Customization
/**/
$auto_approve_new_bookings_is_active = get_bk_option('booking_auto_approve_new_bookings_is_active');
if (trim($auto_approve_new_bookings_is_active) == 'On') {
sendApproveEmails($booking_id, 1);
}
?>
<script type="text/javascript"> setReservedSelectedDates('<?php
echo $bktype;
?>
'); </script> <?php
}
// ReUpdate booking resource TYPE if its needed here
if (!empty($dates)) {
// check to have dates not empty
make_bk_action('wpdev_booking_reupdate_bk_type_to_childs', $booking_id, $bktype, str_replace('|', ',', $dates), array($start_time, $end_time), $formdata);
}
}
?>
, year -> <?php
echo $_POST['cyear'];
?>
</h4>
<table id="courses" width="90%" align="middle" class="result"><tbody><tr><td >S.No</td><td>Roll No</td><td>Name</td><td>Amount</td></tr>
</tbody><tbody>
<?php
include 'mysqlconnect.php';
include 'calc_month.php';
$month = $_POST['cmonth'];
$year = str_replace("20", "", $_POST['cyear']);
$custdb = "pat_mess" . '_' . $month . '_' . $year . '.choices';
$montharr = createDateRangeArray(date("Y-m-d", mktime(0, 0, 0, $_POST['smonth'], $_POST['sday'], $_POST['syear'])), date("Y-m-d", mktime(0, 0, 0, $_POST['emonth'], $_POST['eday'], $_POST['eyear'])));
$result_db = mysql_query("SELECT * FROM {$custdb} ORDER BY s_id ASC");
$cnt2 = 1;
while ($row = mysql_fetch_array($result_db)) {
$grtotal = 0;
$c1 = $row['choices_b'];
$c2 = $row['choices_l'];
$c3 = $row['choices_s'];
$c4 = $row['choices_d'];
foreach ($montharr as $val) {
$grtotal = $grtotal + get_total_cpd_db($c1, 'b', $val, "pat_mess" . '_' . $month . '_' . $year);
}
foreach ($montharr as $val) {
$grtotal = $grtotal + get_total_cpd_db($c2, 'l', $val, "pat_mess" . '_' . $month . '_' . $year);
}
foreach ($montharr as $val) {
function wpdev_bk_insert_new_booking()
{
make_bk_action('check_multiuser_params_for_client_side', $_POST["bktype"]);
global $wpdb;
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// Define init variables
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$dates = $_POST["dates"];
$bktype = $_POST["bktype"];
$formdata = $_POST["form"];
$formdata = escape_any_xss($formdata);
$is_send_emeils = 1;
if (isset($_POST["is_send_emeils"])) {
$is_send_emeils = $_POST["is_send_emeils"];
}
$my_booking_id = 0;
$my_booking_hash = '';
if (isset($_POST['my_booking_hash'])) {
$my_booking_hash = $_POST['my_booking_hash'];
if ($my_booking_hash != '') {
$my_booking_id_type = false;
$my_booking_id_type = apply_bk_filter('wpdev_booking_get_hash_to_id', false, $my_booking_hash);
if ($my_booking_id_type !== false) {
$my_booking_id = $my_booking_id_type[0];
$bktype = $my_booking_id_type[1];
}
}
}
if (strpos($dates, ' - ') !== FALSE) {
$dates = explode(' - ', $dates);
$dates = createDateRangeArray($dates[0], $dates[1]);
}
/// CAPTCHA CHECKING //////////////////////////////////////////////////////////////////////////////////////
$the_answer_from_respondent = $_POST['captcha_user_input'];
$prefix = $_POST['captcha_chalange'];
if (!($the_answer_from_respondent == '' && $prefix == '')) {
$captcha_instance = new wpdevReallySimpleCaptcha();
$correct = $captcha_instance->check($prefix, $the_answer_from_respondent);
if (!$correct) {
$word = $captcha_instance->generate_random_word();
$prefix = mt_rand();
$captcha_instance->generate_image($prefix, $word);
$filename = $prefix . '.png';
$captcha_url = WPDEV_BK_PLUGIN_URL . '/js/captcha/tmp/' . $filename;
$ref = substr($filename, 0, strrpos($filename, '.'));
?>
<script type="text/javascript">
document.getElementById('captcha_input<?php
echo $bktype;
?>
').value = '';
// chnage img
document.getElementById('captcha_img<?php
echo $bktype;
?>
').src = '<?php
echo $captcha_url;
?>
';
document.getElementById('wpdev_captcha_challenge_<?php
echo $bktype;
?>
').value = '<?php
echo $ref;
?>
';
document.getElementById('captcha_msg<?php
echo $bktype;
?>
').innerHTML =
'<div style="height:20px;width:100%;text-align:center;margin:15px auto;"><?php
echo __('Your entered code is incorrect', 'wpdev-booking');
?>
</div>';
document.getElementById('submiting<?php
echo $bktype;
?>
').innerHTML ='';
jQuery('#captcha_input<?php
echo $bktype;
?>
')
.fadeOut( 350 ).fadeIn( 300 )
.fadeOut( 350 ).fadeIn( 400 )
.animate( {opacity: 1}, 4000 )
; // mark red border
jQuery(".wpdev-help-message div")
.css( {'color' : 'red'} )
.animate( {opacity: 1}, 10000 )
.fadeOut( 2000 ); // hide message
document.getElementById('captcha_input<?php
echo $bktype;
?>
').focus(); // make focus to elemnt
</script> <?php
die;
}
}
//////////////////////////////////////////////////////////////////////////////////////////////////////////
$booking_form_show = get_form_content($formdata, $bktype);
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$my_modification_date = "'" . date_i18n('Y-m-d H:i:s') . "'";
// Localize booking modification date
$my_modification_date = 'NOW()';
// Server value modification date
if ($my_booking_id > 0) {
// Edit exist booking
if (strpos($_SERVER['HTTP_REFERER'], 'wp-admin/admin.php?') !== false) {
?>
<script type="text/javascript">
document.getElementById('ajax_working').innerHTML =
'<div class="info_message ajax_message" id="ajax_message">\n\
<div style="float:left;"><?php
echo __('Updating...', 'wpdev-booking');
?>
</div> \n\
<div style="float:left;width:80px;margin-top:-3px;">\n\
<img src="'+wpdev_bk_plugin_url+'/img/ajax-loader.gif">\n\
</div>\n\
</div>';
</script> <?php
}
$update_sql = "UPDATE " . $wpdb->prefix . "booking AS bk SET bk.form='{$formdata}', bk.booking_type={$bktype} , bk.modification_date=" . $my_modification_date . " WHERE bk.booking_id={$my_booking_id};";
if (false === $wpdb->query($wpdb->prepare($update_sql))) {
?>
<script type="text/javascript"> document.getElementById('submiting<?php
echo $bktype;
?>
').innerHTML = '<div style="height:20px;width:100%;text-align:center;margin:15px auto;"><?php
bk_error('Error during updating exist booking in BD', __FILE__, __LINE__);
?>
</div>'; </script> <?php
die;
}
// Check if dates already aproved or no
$slct_sql = "SELECT approved FROM " . $wpdb->prefix . "bookingdates WHERE booking_id IN ({$my_booking_id}) LIMIT 0,1";
$slct_sql_results = $wpdb->get_results($wpdb->prepare($slct_sql));
if (count($slct_sql_results) > 0) {
$is_approved_dates = $slct_sql_results[0]->approved;
}
$delete_sql = "DELETE FROM " . $wpdb->prefix . "bookingdates WHERE booking_id IN ({$my_booking_id})";
if (false === $wpdb->query($wpdb->prepare($delete_sql))) {
?>
<script type="text/javascript"> document.getElementById('submiting<?php
echo $bktype;
?>
').innerHTML = '<div style="height:20px;width:100%;text-align:center;margin:15px auto;"><?php
bk_error('Error during updating exist booking for deleting dates in BD', __FILE__, __LINE__);
?>
</div>'; </script> <?php
die;
}
$booking_id = (int) $my_booking_id;
//Get ID of reservation
} else {
// Add new booking
$sql_insertion = "INSERT INTO " . $wpdb->prefix . "booking (form, booking_type, modification_date) VALUES ('{$formdata}', {$bktype}, " . $my_modification_date . " )";
//debuge($formdata);
if (false === $wpdb->query($wpdb->prepare($sql_insertion))) {
?>
<script type="text/javascript"> document.getElementById('submiting<?php
echo $bktype;
?>
').innerHTML = '<div style="height:20px;width:100%;text-align:center;margin:15px auto;"><?php
bk_error('Error during inserting into BD', __FILE__, __LINE__);
?>
</div>'; </script> <?php
die;
}
// Make insertion into BOOKINGDATES
$booking_id = (int) $wpdb->insert_id;
//Get ID of reservation
$is_approved_dates = '0';
$auto_approve_new_bookings_is_active = get_bk_option('booking_auto_approve_new_bookings_is_active');
if (trim($auto_approve_new_bookings_is_active) == 'On') {
$is_approved_dates = '1';
}
}
$sdform = $_POST['form'];
$my_dates = explode(",", $dates);
$i = 0;
foreach ($my_dates as $md) {
$my_dates[$i] = trim($my_dates[$i]);
$i++;
}
$start_end_time = get_times_from_bk_form($sdform, $my_dates, $bktype);
$start_time = $start_end_time[0];
$end_time = $start_end_time[1];
$my_dates = $start_end_time[2];
make_bk_action('wpdev_booking_post_inserted', $booking_id, $bktype, str_replace('|', ',', $dates), array($start_time, $end_time));
$my_cost = apply_bk_filter('get_booking_cost_from_db', '', $booking_id);
$i = 0;
foreach ($my_dates as $md) {
// Set in dates in such format: yyyy.mm.dd
if ($md != '') {
$md = explode('.', $md);
$my_dates[$i] = $md[2] . '.' . $md[1] . '.' . $md[0];
} else {
unset($my_dates[$i]);
}
// If some dates is empty so remove it // This situation can be if using several bk calendars and some calendars is not checked
$i++;
}
sort($my_dates);
// Sort dates
$my_dates4emeil = '';
$i = 0;
$insert = '';
$my_date_previos = '';
foreach ($my_dates as $my_date) {
$i++;
// Loop through all dates
if (strpos($my_date, '.') !== false) {
if (get_bk_option('booking_recurrent_time') !== 'On') {
$my_date = explode('.', $my_date);
if ($i == 1) {
$date = sprintf("%04d-%02d-%02d %02d:%02d:%02d", $my_date[0], $my_date[1], $my_date[2], $start_time[0], $start_time[1], $start_time[2]);
} elseif ($i == count($my_dates)) {
$date = sprintf("%04d-%02d-%02d %02d:%02d:%02d", $my_date[0], $my_date[1], $my_date[2], $end_time[0], $end_time[1], $end_time[2]);
} else {
$date = sprintf("%04d-%02d-%02d %02d:%02d:%02d", $my_date[0], $my_date[1], $my_date[2], '00', '00', '00');
}
$my_dates4emeil .= $date . ',';
if (!empty($insert)) {
$insert .= ', ';
}
$insert .= "('{$booking_id}', '{$date}', '{$is_approved_dates}' )";
} else {
if ($my_date_previos == $my_date) {
continue;
}
// escape for single day selections.
$my_date_previos = $my_date;
$my_date = explode('.', $my_date);
$date = sprintf("%04d-%02d-%02d %02d:%02d:%02d", $my_date[0], $my_date[1], $my_date[2], $start_time[0], $start_time[1], $start_time[2]);
$my_dates4emeil .= $date . ',';
if (!empty($insert)) {
$insert .= ', ';
}
$insert .= "('{$booking_id}', '{$date}', '{$is_approved_dates}' )";
$date = sprintf("%04d-%02d-%02d %02d:%02d:%02d", $my_date[0], $my_date[1], $my_date[2], $end_time[0], $end_time[1], $end_time[2]);
$my_dates4emeil .= $date . ',';
if (!empty($insert)) {
$insert .= ', ';
}
$insert .= "('{$booking_id}', '{$date}', '{$is_approved_dates}' )";
}
}
}
$my_dates4emeil = substr($my_dates4emeil, 0, -1);
$my_dates4emeil_check_in_out = explode(',', $my_dates4emeil);
$my_check_in_date = change_date_format($my_dates4emeil_check_in_out[0]);
$my_check_out_date = change_date_format($my_dates4emeil_check_in_out[count($my_dates4emeil_check_in_out) - 1]);
/* // This add 1 more day for check out day
$my_check_out_date = $my_dates4emeil_check_in_out[ count($my_dates4emeil_check_in_out)-1 ];
$dt = trim($my_check_out_date);
$dta = explode(' ',$dt);
$dta = $dta[0];
$dta = explode('-',$dta);
$my_check_out_date = date('Y-m-d H:i:s' , mktime(0, 0, 0, $dta[1], ($dta[2]+1), $dta[0] ));
$my_check_out_date = change_date_format($my_check_out_date);
/**/
if (!empty($insert)) {
if (false === $wpdb->query($wpdb->prepare("INSERT INTO " . $wpdb->prefix . "bookingdates (booking_id, booking_date, approved) VALUES " . $insert))) {
?>
<script type="text/javascript"> document.getElementById('submiting<?php
echo $bktype;
?>
').innerHTML = '<div style="height:20px;width:100%;text-align:center;margin:15px auto;"><?php
bk_error('Error during inserting into BD - Dates', __FILE__, __LINE__);
?>
</div>'; </script> <?php
die;
}
}
if (function_exists('get_booking_title')) {
$bk_title = get_booking_title($bktype);
} else {
$bk_title = '';
}
if ($my_booking_id > 0) {
// For editing exist booking
$mail_sender = htmlspecialchars_decode(get_bk_option('booking_email_modification_adress'));
$mail_subject = htmlspecialchars_decode(get_bk_option('booking_email_modification_subject'));
$mail_body = htmlspecialchars_decode(get_bk_option('booking_email_modification_content'));
$mail_subject = apply_bk_filter('wpdev_check_for_active_language', $mail_subject);
$mail_body = apply_bk_filter('wpdev_check_for_active_language', $mail_body);
if (function_exists('get_booking_title')) {
$bk_title = get_booking_title($bktype);
} else {
$bk_title = '';
}
$booking_form_show = get_form_content($formdata, $bktype);
$mail_body_to_send = str_replace('[bookingtype]', $bk_title, $mail_body);
if (get_bk_option('booking_date_view_type') == 'short') {
$my_dates_4_send = get_dates_short_format(get_dates_str($booking_id));
} else {
$my_dates_4_send = change_date_format(get_dates_str($booking_id));
}
$mail_body_to_send = str_replace('[dates]', $my_dates_4_send, $mail_body_to_send);
$mail_body_to_send = str_replace('[check_in_date]', $my_check_in_date, $mail_body_to_send);
$mail_body_to_send = str_replace('[check_out_date]', $my_check_out_date, $mail_body_to_send);
$mail_body_to_send = str_replace('[id]', $booking_id, $mail_body_to_send);
$mail_body_to_send = str_replace('[content]', $booking_form_show['content'], $mail_body_to_send);
if (!isset($denyreason)) {
$denyreason = '';
}
$mail_body_to_send = str_replace('[denyreason]', $denyreason, $mail_body_to_send);
$mail_body_to_send = str_replace('[name]', $booking_form_show['name'], $mail_body_to_send);
$mail_body_to_send = str_replace('[cost]', $my_cost, $mail_body_to_send);
if (isset($booking_form_show['secondname'])) {
$mail_body_to_send = str_replace('[secondname]', $booking_form_show['secondname'], $mail_body_to_send);
}
$mail_body_to_send = str_replace('[siteurl]', htmlspecialchars_decode('<a href="' . site_url() . '">' . site_url() . '</a>'), $mail_body_to_send);
$mail_body_to_send = apply_bk_filter('wpdev_booking_set_booking_edit_link_at_email', $mail_body_to_send, $booking_id);
$mail_subject = str_replace('[name]', $booking_form_show['name'], $mail_subject);
if (isset($booking_form_show['secondname'])) {
$mail_subject = str_replace('[secondname]', $booking_form_show['secondname'], $mail_subject);
}
$mail_recipient = $booking_form_show['email'];
$mail_headers = "From: {$mail_sender}\n";
$mail_headers .= "Content-Type: text/html\n";
if (get_bk_option('booking_is_email_modification_adress') != 'Off') {
// Send to the Visitor
if (strpos($mail_recipient, '@blank.com') === false && strpos($mail_body_to_send, '*****@*****.**') === false) {
if ($is_send_emeils != 0) {
@wp_mail($mail_recipient, $mail_subject, $mail_body_to_send, $mail_headers);
}
}
// Send to the Admin also
$mail_recipient = htmlspecialchars_decode(get_bk_option('booking_email_reservation_adress'));
$is_email_modification_send_copy_to_admin = get_bk_option('booking_is_email_modification_send_copy_to_admin');
if ($is_email_modification_send_copy_to_admin == 'On') {
if (strpos($mail_recipient, '@blank.com') === false && strpos($mail_body_to_send, '*****@*****.**') === false) {
if ($is_send_emeils != 0) {
@wp_mail($mail_recipient, $mail_subject, $mail_body_to_send, $mail_headers);
}
}
}
}
//debuge($_SERVER);
if (strpos($_SERVER['HTTP_REFERER'], 'wp-admin/admin.php?') === false) {
do_action('wpdev_new_booking', $booking_id, $bktype, str_replace('|', ',', $dates), array($start_time, $end_time), $sdform);
}
?>
<script type="text/javascript">
<?php
if (strpos($_SERVER['HTTP_REFERER'], 'wp-admin/admin.php?') === false) {
?>
//document.getElementById('submiting<?php
echo $bktype;
?>
').innerHTML = '<div class=\"submiting_content\" ><?php
echo get_bk_option('booking_title_after_reservation');
?>
</div>';
//jQuery('.submiting_content').fadeOut(<?php
echo get_bk_option('booking_title_after_reservation_time');
?>
);
setReservedSelectedDates('<?php
echo $bktype;
?>
');
<?php
} else {
?>
document.getElementById('ajax_message').innerHTML = '<?php
echo __('Updated successfully', 'wpdev-booking');
?>
';
jQuery('#ajax_message').fadeOut(1000);
document.getElementById('submiting<?php
echo $bktype;
?>
').innerHTML = '<div style="height:20px;width:100%;text-align:center;margin:15px auto;"><?php
echo __('Updated successfully', 'wpdev-booking');
?>
</div>';
location.href='admin.php?page=<?php
echo WPDEV_BK_PLUGIN_DIRNAME . '/' . WPDEV_BK_PLUGIN_FILENAME;
?>
wpdev-booking&booking_type=<?php
echo $bktype;
?>
&booking_id_selection=<?php
echo $my_booking_id;
?>
';
<?php
}
?>
</script> <?php
} else {
if (count($my_dates) > 0) {
//// For inserting NEW booking
// Sending mail ///////////////////////////////////////////////////////
$mail_sender = htmlspecialchars_decode(get_bk_option('booking_email_reservation_from_adress'));
//'"'. 'Booking sender' . '" <' . $booking_form_show['email'].'>';
$mail_recipient = htmlspecialchars_decode(get_bk_option('booking_email_reservation_adress'));
//'"Booking receipent" <' .get_option('admin_email').'>';
$mail_subject = htmlspecialchars_decode(get_bk_option('booking_email_reservation_subject'));
$mail_body = htmlspecialchars_decode(get_bk_option('booking_email_reservation_content'));
$mail_subject = apply_bk_filter('wpdev_check_for_active_language', $mail_subject);
$mail_body = apply_bk_filter('wpdev_check_for_active_language', $mail_body);
$mail_body = str_replace('[bookingtype]', $bk_title, $mail_body);
if (get_bk_option('booking_date_view_type') == 'short') {
$my_dates_4_send = get_dates_short_format($my_dates4emeil);
} else {
$my_dates_4_send = change_date_format($my_dates4emeil);
}
$mail_body = str_replace('[dates]', $my_dates_4_send, $mail_body);
$mail_body = str_replace('[check_in_date]', $my_check_in_date, $mail_body);
$mail_body = str_replace('[check_out_date]', $my_check_out_date, $mail_body);
$mail_body = str_replace('[id]', $booking_id, $mail_body);
$mail_body = str_replace('[content]', $booking_form_show['content'], $mail_body);
$mail_body = str_replace('[name]', $booking_form_show['name'], $mail_body);
$mail_body = str_replace('[cost]', $my_cost, $mail_body);
$mail_body = str_replace('[siteurl]', htmlspecialchars_decode('<a href="' . site_url() . '">' . site_url() . '</a>'), $mail_body);
$mail_body = str_replace('[moderatelink]', htmlspecialchars_decode('<a href="' . site_url() . '/wp-admin/admin.php?page=' . WPDEV_BK_PLUGIN_DIRNAME . '/' . WPDEV_BK_PLUGIN_FILENAME . 'wpdev-booking&booking_type=' . $bktype . '&moderate_id=' . $booking_id . '">' . __('here', 'wpdev-booking') . '</a>'), $mail_body);
$mail_body = apply_bk_filter('wpdev_booking_set_booking_edit_link_at_email', $mail_body, $booking_id);
if (isset($booking_form_show['secondname'])) {
$mail_body = str_replace('[secondname]', $booking_form_show['secondname'], $mail_body);
}
$mail_subject = str_replace('[name]', $booking_form_show['name'], $mail_subject);
if (isset($booking_form_show['secondname'])) {
$mail_subject = str_replace('[secondname]', $booking_form_show['secondname'], $mail_subject);
}
$mail_headers = "From: {$mail_sender}\n";
$mail_headers .= "Content-Type: text/html\n";
if (strpos($mail_recipient, '[visitoremeil]') !== false) {
$mail_recipient = str_replace('[visitoremeil]', $booking_form_show['email'], $mail_recipient);
}
if (get_bk_option('booking_is_email_reservation_adress') != 'Off') {
if (strpos($mail_recipient, '@blank.com') === false && strpos($mail_body, '*****@*****.**') === false) {
if ($is_send_emeils != 0) {
@wp_mail($mail_recipient, $mail_subject, $mail_body, $mail_headers);
}
}
}
/////////////////////////////////////////////////////////////////////////
if (get_bk_option('booking_is_email_newbookingbyperson_adress') == 'On') {
$mail_sender = htmlspecialchars_decode(get_bk_option('booking_email_newbookingbyperson_adress'));
//'"'. 'Booking sender' . '" <' . $booking_form_show['email'].'>';
$mail_recipient = $booking_form_show['email'];
$mail_subject = htmlspecialchars_decode(get_bk_option('booking_email_newbookingbyperson_subject'));
$mail_body = htmlspecialchars_decode(get_bk_option('booking_email_newbookingbyperson_content'));
$mail_subject = apply_bk_filter('wpdev_check_for_active_language', $mail_subject);
$mail_body = apply_bk_filter('wpdev_check_for_active_language', $mail_body);
$mail_body = str_replace('[bookingtype]', $bk_title, $mail_body);
if (get_bk_option('booking_date_view_type') == 'short') {
$my_dates_4_send = get_dates_short_format($my_dates4emeil);
} else {
$my_dates_4_send = change_date_format($my_dates4emeil);
}
$mail_body = str_replace('[dates]', $my_dates_4_send, $mail_body);
$mail_body = str_replace('[check_in_date]', $my_check_in_date, $mail_body);
$mail_body = str_replace('[check_out_date]', $my_check_out_date, $mail_body);
$mail_body = str_replace('[id]', $booking_id, $mail_body);
$mail_body = str_replace('[content]', $booking_form_show['content'], $mail_body);
$mail_body = str_replace('[name]', $booking_form_show['name'], $mail_body);
$mail_body = str_replace('[cost]', $my_cost, $mail_body);
$mail_body = str_replace('[siteurl]', htmlspecialchars_decode('<a href="' . site_url() . '">' . site_url() . '</a>'), $mail_body);
$mail_body = apply_bk_filter('wpdev_booking_set_booking_edit_link_at_email', $mail_body, $booking_id);
if (isset($booking_form_show['secondname'])) {
$mail_body = str_replace('[secondname]', $booking_form_show['secondname'], $mail_body);
}
$mail_subject = str_replace('[name]', $booking_form_show['name'], $mail_subject);
if (isset($booking_form_show['secondname'])) {
$mail_subject = str_replace('[secondname]', $booking_form_show['secondname'], $mail_subject);
}
$mail_headers = "From: {$mail_sender}\n";
$mail_headers .= "Content-Type: text/html\n";
if (strpos($mail_recipient, '[visitoremeil]') !== false) {
$mail_recipient = str_replace('[visitoremeil]', $booking_form_show['email'], $mail_recipient);
}
if (strpos($mail_recipient, '@blank.com') === false) {
if (strpos($mail_recipient, '@blank.com') === false && strpos($mail_body, '*****@*****.**') === false) {
if ($is_send_emeils != 0) {
@wp_mail($mail_recipient, $mail_subject, $mail_body, $mail_headers);
}
}
}
}
}
do_action('wpdev_new_booking', $booking_id, $bktype, str_replace('|', ',', $dates), array($start_time, $end_time), $sdform);
?>
<script type="text/javascript"> setReservedSelectedDates('<?php
echo $bktype;
?>
'); </script> <?php
}
// ReUpdate booking resource TYPE if its needed here
if (!empty($dates)) {
// check to have dates not empty
make_bk_action('wpdev_booking_reupdate_bk_type_to_childs', $booking_id, $bktype, str_replace('|', ',', $dates), array($start_time, $end_time), $sdform);
}
}
public function getLeadsChartData($period)
{
if (!DashboardCommon::is_su()) {
$client_calls_where = " AND gsm_number IN (" . $this->get_gsm_number() . ") AND test_data=0\n {$this->calls_data_limit_clause}\n ORDER BY call_start DESC";
$client_email_where = " AND client_id IN ('" . implode('\',\'', $this->get_unbounce_ids()) . "') AND test_data=0\n ORDER BY email_date DESC";
}
$data = array();
$period_days = array();
$date_filter = "Y-m-d";
if ($period == 'lifetime') {
$period_days = getMonths($this->from, $this->to);
$date_filter = "Y-m";
} elseif ($period == 'last_30_days' || $period == 'last_7_days' || $period == 'yesterday' || $period == 'month' || $period == 'daily' || $period == 'today' || $period == 'this_month' || $period == 'custom' || $period == 'last_month') {
$period_days = createDateRangeArray($this->from, $this->to);
} else {
$period_days = createDateRangeArray($this->from, $this->to);
}
if (!empty($period_days)) {
foreach ($period_days as $date) {
if ($date_filter === 'Y-m-d') {
$date_filtered = $date;
} else {
$date_filtered = date_format($date, "{$date_filter}");
}
$q1 = "SELECT count(*) as total_calls FROM calls WHERE call_start LIKE '%" . $date_filtered . "%' {$client_calls_where} ";
$rc = DashboardCommon::db()->Execute($q1);
$c_total = $rc->fields['total_calls'];
if ($c_total == '') {
$c_total = 0;
}
$q2 = "SELECT count(*) as total_emails FROM emails WHERE email_date LIKE '%" . $date_filtered . "%' {$client_email_where}";
$re = DashboardCommon::db()->Execute($q2);
$e_total = $re->fields['total_emails'];
if ($e_total == '') {
$e_total = 0;
}
$sql_leads = "SELECT * , tcalls+temails as total_leads\n FROM\n (SELECT \n COUNT(DISTINCT DATE_FORMAT(call_start,'%y-%m-%d') , gsm_number) as tcalls\n FROM calls \n WHERE\n call_start LIKE '%" . $date_filtered . "%' {$client_calls_where}\n ) as a , \n (SELECT \n COUNT(*) as temails\n FROM emails \n WHERE\n email_date LIKE '%" . $date_filtered . "%' {$client_email_where}\n ) as b";
//echo $sql_leads; die();
$res_leads = DashboardCommon::db()->Execute($sql_leads);
$tot_leads = $res_leads->fields['total_leads'] != '' ? $res_leads->fields['total_leads'] : 0;
$row = array('y' => $date_filtered, 'a' => $c_total, 'b' => $e_total, 'c' => $tot_leads);
$data[] = $row;
}
}
return $data;
}
$_POST['gwpm_starsign'] = rand(1, 26);
$_POST['gwpm_user'] = '******';
$_POST['gwpm_caste'] = 'Mudliyar';
$_POST['gwpm_zodiac'] = rand(1, 12);
$_POST['gwpm_contact_no'] = rand(1, 12) * 100000000 + 989898 + rand(5000, 10000);
$gwpm_education['qualification'] = "" . rand(1, 4);
$gwpm_education['qualification_other'] = "" . 'Other';
$gwpm_education['specialization'] = "" . rand(1, 4);
$gwpm_education['status'] = "" . rand(1, 4);
$_POST['gwpm_education'] = $gwpm_education;
$dynaKeys = getDynamicFieldKeys();
foreach ($dynaKeys as $__keys) {
echo "<br /> Dyna: " . $__keys;
$_POST[$__keys] = "" . rand(1, 3);
}
$abt = createDateRangeArray('1980-10-01', '1985-10-05');
$newdata = $abt[0];
echo $newdata . "<br />";
$_POST['gwpm_dob'] = $newdata;
// $profileObj = new GwpmProfileVO($_POST);
$profileObj = new GwpmProfileVO($_POST, $dynaKeys);
$profileObj->gwpm_profile_photo = $_FILES["gwpm_profile_photo"];
$validateObj = $profileObj->validate();
if (sizeof($validateObj) == 0) {
$mymodel->updateUser($profileObj);
echo __('success_message', 'Profile updated successfully!!' . '<br />');
} else {
echo __('Please correct the below fields: ' . '<br />');
print_r($validateObj);
echo "<>br />";
}
public function process(Vtiger_Request $request)
{
${"GLOBALS"}["yhxxwwp"] = "response";
${"GLOBALS"}["pxeqxzb"] = "adb";
${${"GLOBALS"}["pxeqxzb"]} = PearDatabase::getInstance();
${${"GLOBALS"}["yhxxwwp"]} = new Vtiger_Response();
try {
${"GLOBALS"}["oiwytok"] = "destParts";
${"GLOBALS"}["tpetshnvd"] = "endDate";
$iswounrnek = "result";
$uobfcxfl = "endDate";
$horlccannv = "max";
${"GLOBALS"}["bwjsfawphw"] = "max";
${${"GLOBALS"}["bibzqs"]} = $request->get("source");
${${"GLOBALS"}["bppobsjc"]} = $request->get("destination");
$ophrsqnqox = "module_name";
${${"GLOBALS"}["woengridn"]} = date("Y-m-d", strtotime($request->get("startDate")));
$qdolutxmeo = "instance";
$pjnbbpuuqxo = "sourceParts";
$hlftbibsr = "days";
$wnpszmuoobf = "startDate";
$hmvrqvo = "destination";
${"GLOBALS"}["ijyhdjitchvp"] = "source";
${$uobfcxfl} = date("Y-m-d", strtotime($request->get("endDate")));
${${"GLOBALS"}["urjerclfrbq"]} = $request->get("module_name");
$pkfjjhq = "destParts";
$mdkfudjveoo = "sourceParts";
${$mdkfudjveoo} = explode("__", ${${"GLOBALS"}["ijyhdjitchvp"]});
${"GLOBALS"}["qervoel"] = "startDate";
${${"GLOBALS"}["oiwytok"]} = explode("__", ${$hmvrqvo});
${$qdolutxmeo} = CRMEntity::getInstance(${$ophrsqnqox});
$jdmekf = "endDate";
$xtewmsf = "result";
${"GLOBALS"}["uwrtufgmq"] = "days";
${${"GLOBALS"}["tlujtnfudsoo"]} = "SELECT COUNT(*) as num, DATE(timestamp) as `date`\n FROM vtiger_wf_log\n WHERE lastBlockId = " . ${$pjnbbpuuqxo}[1] . " AND lastBlockOutput = '" . ${${"GLOBALS"}["ecdsgnnepizb"]}[2] . "' AND blockID = '" . ${$pkfjjhq}[1] . "' AND timestamp >= '" . ${${"GLOBALS"}["qervoel"]} . " 00:00:00' AND timestamp <= '" . ${${"GLOBALS"}["tpetshnvd"]} . " 23:59:00' GROUP BY DATE(timestamp)";
$jvkelzjdi = "interval";
$iernywmknrr = "day";
${$iswounrnek} = $adb->query(${${"GLOBALS"}["tlujtnfudsoo"]});
${${"GLOBALS"}["ydwzvzcgkpv"]} = array();
$amqwluuvjyg = "max";
${${"GLOBALS"}["kelygfmapmx"]} = 9999;
${${"GLOBALS"}["bwjsfawphw"]} = 0;
${${"GLOBALS"}["uwrtufgmq"]} = createDateRangeArray(${$wnpszmuoobf}, ${$jdmekf});
${"GLOBALS"}["crbuhjvng"] = "max";
while (${${"GLOBALS"}["tvcadb"]} = $adb->fetch_array(${${"GLOBALS"}["rdqhjsrop"]})) {
$zlmkdbsrt = "max";
${"GLOBALS"}["pwkkjdeyn"] = "row";
${${"GLOBALS"}["ydwzvzcgkpv"]}[${${"GLOBALS"}["tvcadb"]}["date"]] = ${${"GLOBALS"}["tvcadb"]}["num"];
if (${${"GLOBALS"}["pwkkjdeyn"]}["num"] < ${${"GLOBALS"}["kelygfmapmx"]}) {
$qybesgi = "min";
$xewkelnygnh = "row";
${$qybesgi} = ${$xewkelnygnh}["num"];
}
if (${${"GLOBALS"}["tvcadb"]}["num"] > ${$zlmkdbsrt}) {
${"GLOBALS"}["fqjmvxecq"] = "row";
${${"GLOBALS"}["jebwgsoqcau"]} = ${${"GLOBALS"}["fqjmvxecq"]}["num"];
}
}
${${"GLOBALS"}["rdqhjsrop"]} = array();
foreach (${${"GLOBALS"}["hiokisn"]} as ${$iernywmknrr}) {
${"GLOBALS"}["mkcstfyyu"] = "day";
if (isset(${${"GLOBALS"}["ydwzvzcgkpv"]}[${${"GLOBALS"}["mkcstfyyu"]}])) {
${"GLOBALS"}["bzxmqyitlr"] = "data";
$ponccidnqdn = "day";
${${"GLOBALS"}["rdqhjsrop"]}[] = array(date("d-M-Y", strtotime(${${"GLOBALS"}["gkqzyqt"]})), ${${"GLOBALS"}["bzxmqyitlr"]}[${$ponccidnqdn}]);
} else {
${"GLOBALS"}["jnnfrdtxydq"] = "day";
${"GLOBALS"}["nqlunrvsrc"] = "result";
${${"GLOBALS"}["nqlunrvsrc"]}[] = array(date("d-M-Y", strtotime(${${"GLOBALS"}["jnnfrdtxydq"]})), 0);
}
}
if (count(${$hlftbibsr}) > 10) {
$rbntpxsufr = "interval";
${$rbntpxsufr} = 7;
} else {
${"GLOBALS"}["wkwenrq"] = "interval";
${${"GLOBALS"}["wkwenrq"]} = 1;
}
${"GLOBALS"}["bgtxppfnvy"] = "min";
if (${${"GLOBALS"}["crbuhjvng"]} > 200) {
${${"GLOBALS"}["wahhniepks"]} = 50;
} elseif (${$horlccannv} > 100) {
${${"GLOBALS"}["wahhniepks"]} = 25;
} elseif (${${"GLOBALS"}["jebwgsoqcau"]} > 50) {
${${"GLOBALS"}["wahhniepks"]} = 10;
} elseif (${$amqwluuvjyg} >= 6) {
$qkrnzmkcpyi = "Xinterval";
${$qkrnzmkcpyi} = 2;
} else {
$prtlep = "Xinterval";
${$prtlep} = 1;
}
${${"GLOBALS"}["ydwzvzcgkpv"]} = array("Yinterval" => ${$jvkelzjdi}, "Xinterval" => ${${"GLOBALS"}["wahhniepks"]}, "min" => intval(${${"GLOBALS"}["bgtxppfnvy"]}), "max" => intval(${${"GLOBALS"}["jebwgsoqcau"]}), "data" => ${$xtewmsf});
$response->setResult(array("success" => true, "data" => ${${"GLOBALS"}["ydwzvzcgkpv"]}));
} catch (Exception $exp) {
$response->setResult(array("success" => false, "error" => $exp->getMessage()));
}
$response->emit();
}
$pending_dates = array();
$curret_user_id = $_SESSION['user_id'];
$tot_hrs = 0;
$holidays = array();
$query = "SELECT date FROM amz_holidays where status='1' AND deleted='0'";
$result = $conn->runsql($query, $dbcon);
while ($row = mysqli_fetch_object($result)) {
$holidays[] = $row->date;
}
$query = "SELECT user_id,user_mail,last_entry_on,create_date FROM amz_login where user_id='{$curret_user_id}'";
$result = $conn->runsql($query, $dbcon);
while ($row = mysqli_fetch_object($result)) {
$current_user = $row->user_id;
$last_entry_date = $row->last_entry_on == "" ? $row->create_date : $row->last_entry_on;
$today_date = date('Y-m-d', $_SERVER['REQUEST_TIME']);
$aryDates = createDateRangeArray($last_entry_date, $today_date);
$size = sizeof($aryDates);
for ($i = 0; $i < $size; $i++) {
if (!in_array($aryDates[$i], $holidays)) {
$single_date = $aryDates[$i];
$time_diff = getTimes($single_date, $today_date);
if ($time_diff >= 24) {
$tot_hrs = 0;
$query_1 = "SELECT time FROM user_tasks WHERE date='{$single_date}' AND user_id='{$current_user}'";
$result_1 = $conn->runsql($query_1, $dbcon);
if (mysqli_num_rows($result_1)) {
while ($result_row_1 = mysqli_fetch_object($result_1)) {
//$tot_hrs = $tot_hrs + $result_row_1->time;
$tot_hrs += strtotime($result_row_1->time) - strtotime("00:00:00");
}
//echo $tot_hrs;
function dailyreport()
{
$search = $this->search_post($_POST);
$startdate = $_GET['startdate'];
$enddate = $_GET['enddate'];
//-- generate daily graph data --//
if ($startdate == '' && $enddate == '') {
$startdate = date('d-m-Y', strtotime(date('Y-m-01')));
$enddate = date('Y-m-d');
}
if ($startdate == '') {
$startdate = date('d-m-Y', strtotime(date('Y-m-01')));
}
if ($enddate == '') {
$enddate = date('Y-m-d');
}
$dateRange = createDateRangeArray($startdate, $enddate);
//-- helper to get date range
$dailyreport = $this->Ads_analytics_model->getDailyReport($dateRange);
echo json_encode($dailyreport);
die;
//-----------------------------//
}
