$monthsInYear = array("1", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12");
$textMonths = array("Jan", "Feb", "Mar", "Apr", "May", "June", "July", "Aug", "Sept", "Oct", "Nov", "Dec");
$testing = sortByMonth($quotes, $currentMonth, $Theyear);
$poppyseeds = getTheDate($quotes, $currentMonth, $Theyear);
function dates_month($month, $year)
{
$num = cal_days_in_month(CAL_GREGORIAN, $month, $year);
$dates_month = array();
for ($i = 1; $i <= $num; $i++) {
$mktime = mktime(0, 0, 0, $month, $i, $year);
$date = date("n-j-Y", $mktime);
$dates_month[$i] = $date;
}
return $dates_month;
}
$dates = dates_month($currentMonth, $Theyear);
if (count($testing) > 0) {
?>
<section class="numberContainer">
<span class="top"> Number of Quotes in <?php
echo $textMonths[$currentMonth - 1];
?>
</span>
<p> <?php
echo $numQuotes = count($testing);
?>
</p>
</section>
<section class="numberContainer">
<span class="top">Number of Quoted Pieces in <?php
}
/* Single Select Filter */
if (count($selectedMonths) == 1) {
$selMon = $selectedMonths[0];
function dates_month($month, $year)
{
$num = cal_days_in_month(CAL_GREGORIAN, $month, $year);
$dates_month = array();
for ($i = 1; $i <= $num; $i++) {
$mktime = mktime(0, 0, 0, $month, $i, $year);
$date = date("d", $mktime);
$dates_month[$i] = $date;
}
return $dates_month;
}
$listDays = dates_month($selMon, $selectedYear);
//print_r(dates_month($selMon,$selectedYear));
foreach ($listDays as $k => $v) {
$table_qry[] = " " . (count($table_qry) > 1 ? ' OR ' : ' ') . " (MONTH(add_date)='" . mysql_prep($selMon) . "' AND YEAR(add_date)='" . mysql_prep($selectedYear) . "') ";
$graph_lab[] = '"' . $LETHE_MONTH_NAMES['short'][$selMon] . ' ' . $v . '"';
$graph_data['click'][] = cntData("SELECT ID FROM " . db_table_pref . "reports WHERE OID=" . set_org_id . " AND pos=0 AND CID=" . $ID . " AND DAY(add_date)='" . mysql_prep($v) . "' AND MONTH(add_date)='" . mysql_prep($selMon) . "' AND YEAR(add_date)='" . mysql_prep($selectedYear) . "'");
$graph_data['open'][] = cntData("SELECT ID FROM " . db_table_pref . "reports WHERE OID=" . set_org_id . " AND pos=1 AND CID=" . $ID . " AND DAY(add_date)='" . mysql_prep($v) . "' AND MONTH(add_date)='" . mysql_prep($selMon) . "' AND YEAR(add_date)='" . mysql_prep($selectedYear) . "'");
$graph_data['bounce'][] = cntData("SELECT ID FROM " . db_table_pref . "reports WHERE OID=" . set_org_id . " AND pos=2 AND CID=" . $ID . " AND DAY(add_date)='" . mysql_prep($v) . "' AND MONTH(add_date)='" . mysql_prep($selMon) . "' AND YEAR(add_date)='" . mysql_prep($selectedYear) . "'");
}
} else {
foreach ($selectedMonths as $k => $v) {
$table_qry[] = " " . (count($table_qry) > 1 ? ' OR ' : ' ') . " (MONTH(add_date)='" . mysql_prep($v) . "' AND YEAR(add_date)='" . mysql_prep($selectedYear) . "') ";
$graph_lab[] = '"' . $LETHE_MONTH_NAMES['short'][$v] . ' ' . date("y", strtotime("01-01-" . $selectedYear)) . '"';
$graph_data['click'][] = cntData("SELECT ID FROM " . db_table_pref . "reports WHERE OID=" . set_org_id . " AND pos=0 AND CID=" . $ID . " AND MONTH(add_date)='" . mysql_prep($v) . "' AND YEAR(add_date)='" . mysql_prep($selectedYear) . "'");
$graph_data['open'][] = cntData("SELECT ID FROM " . db_table_pref . "reports WHERE OID=" . set_org_id . " AND pos=1 AND CID=" . $ID . " AND MONTH(add_date)='" . mysql_prep($v) . "' AND YEAR(add_date)='" . mysql_prep($selectedYear) . "'");
$graph_data['bounce'][] = cntData("SELECT ID FROM " . db_table_pref . "reports WHERE OID=" . set_org_id . " AND pos=2 AND CID=" . $ID . " AND MONTH(add_date)='" . mysql_prep($v) . "' AND YEAR(add_date)='" . mysql_prep($selectedYear) . "'");
}
}
$theArray = array_unique($actualDate);
$theArray = array_values($theArray);
function dates_month($month, $year)
{
$num = cal_days_in_month(CAL_GREGORIAN, $month, $year);
$dates_month = array();
for ($i = 1; $i <= $num; $i++) {
$mktime = mktime(0, 0, 0, $month, $i, $year);
$date = date("n-d-Y", $mktime);
$dates_month[$i] = $date;
}
return $dates_month;
}
$dates = dates_month($currentMonth, 2015);
/*
foreach($month as $key => $theMonth) {
if($theMonth == $currentMonth)
echo $actualDate[$key];
}
*/
?>
<div class="activeQuotes">
<p class="badgeTitle">
Quotes Made in <?php
echo $dasMonth;
?>
»
</p>
<div class="data">
$link = mysqli_connect(DB_HOST, DB_USER, DB_PASS, DB_SCHEMA) or die(mysqli_error($link));
//: End
//: Content
$fleetdayobj = new fleetDayHandler();
function dates_month($month, $year)
{
$num = cal_days_in_month(CAL_GREGORIAN, $month, $year);
$dates_month = array();
for ($i = 1; $i <= $num; $i++) {
$mktime = mktime(0, 0, 0, $month, $i, $year);
$date = date("d-M-Y", $mktime);
$dates_month[$i] = $date;
}
return $dates_month;
}
$days = dates_month(date("m"), date("Y"));
foreach ($days as $day) {
if (date("d", strtotime($day)) > 31) {
continue;
}
$fleetData = $fleetdayobj->pullT24FleetData(date("d", strtotime($day)));
$fleet_trucks = (array) array();
foreach ($fleetData as $row) {
$fleet_trucks[$row["fleet_id"]][] = $row;
}
unset($fleetData);
// print_r($fleet_trucks);
$t24Budget = (array) array();
foreach ($fleet_trucks as $fleetId => $truck) {
$trucks = (string) "";
foreach ($truck as $data) {
