* Justin Kelly
*
* Last edited:
* 2008-05-13
*
* License:
* GPL v3
*
* Website:
* http://www.simpleinvoices.org
*/
checkLogin();
$domain_id = domain_id::get();
function firstOfMonth()
{
return date("Y-m-d", strtotime('01-' . date('m') . '-' . date('Y') . ' 00:00:00'));
}
function lastOfMonth()
{
return date("Y-m-d", strtotime('-1 second', strtotime('+1 month', strtotime('01-' . date('m') . '-' . date('Y') . ' 00:00:00'))));
}
$start_date = isset($_POST['start_date']) ? $_POST['start_date'] : firstOfMonth();
$end_date = isset($_POST['end_date']) ? $_POST['end_date'] : lastOfMonth();
$sql = "SELECT e.amount AS expense\n , ea.name AS account \n\tFROM " . TB_PREFIX . "expense e \n\t\t LEFT JOIN " . TB_PREFIX . "expense_account ea \n\t\t\tON (e.expense_account_id = ea.id AND e.domain_id = ea.domain_id)\n\tWHERE\n\t e.domain_id = :domain_id\n\tAND e.date BETWEEN '{$start_date}' AND '{$end_date}' \n\tGROUP BY account \n\tORDER BY account ASC;";
$sth = $db->query($sql, ':domain_id', $domain_id);
$accounts = $sth->fetchAll();
$smarty->assign('accounts', $accounts);
$smarty->assign('start_date', $start_date);
$smarty->assign('end_date', $end_date);
$smarty->assign('pageActive', 'report');
$smarty->assign('active_tab', '#home');
* License:
* GPL v3
*
* Website:
* http://www.simpleinvoices.org
*/
checkLogin();
function firstOfMonth()
{
return date("Y-m-d", strtotime('01-' . date('m') . '-' . date('Y') . ' 00:00:00'));
}
function lastOfMonth()
{
return date("Y-m-d", strtotime('-1 second', strtotime('+1 month', strtotime('01-' . date('m') . '-' . date('Y') . ' 00:00:00'))));
}
isset($_POST['start_date']) ? $start_date = $_POST['start_date'] : ($start_date = firstOfMonth());
isset($_POST['end_date']) ? $end_date = $_POST['end_date'] : ($end_date = lastOfMonth());
$sql = "select \n e.amount as expense, \n e.status as status, \n ea.name as account,\n (select sum(tax_amount) from si_expense_item_tax where expense_id = e.id) as tax,\n (select tax + e.amount) as total,\n (CASE WHEN status = 1 THEN '" . $LANG['paid'] . "'\n WHEN status = 0 THEN '" . $LANG['not_paid'] . "'\n END) AS status_wording\n from \n si_expense e, \n si_expense_account ea \n where \n e.expense_account_id = ea.id \n and \n e.date between '{$start_date}' and '{$end_date}'";
$sth = $db->query($sql);
$accounts = $sth->fetchAll();
$payment = new payment();
$payment->start_date = $start_date;
$payment->end_date = $end_date;
$payment->filter = "date";
$payments = $payment->select_all();
$invoice = new invoice();
$invoice->start_date = $start_date;
$invoice->end_date = $end_date;
$invoice->having = "date_between";
$invoice->sort = "preference";
$invoice_all = $invoice->select_all();
function longestAbnd()
{
global $curMonth, $FTE_Num;
$summary_id = 8;
for ($i = 1; $i <= $curMonth; $i++) {
$query = "\t\tSELECT\t\tmax(C.duration) ";
$query .= "\t\tFROM\t\tusi_tbl_calllog as C";
$query .= "\t\tWHERE \tdcontext = 'Marwood_Day' ";
$query .= "\t\tAND\t\t\tstart BETWEEN '" . firstOfMonth($i) . "' AND '" . lastOfMonth($i) . " 23:23:59'";
$query .= "\t\tAND\t\t\tdstchannel = ''";
$query .= "\t\tAND \t\tsubstr(clid,12,8) <> 'asterisk' ";
$result = mysql_query($query) or die('Query failed: ' . mysql_info());
$rows = mysql_fetch_array($result, MYSQL_NUM);
if ($rows[0] == NULL) {
$longAbndArr[$i] = "0:00";
} else {
if ($rows[0] % 60 < 10) {
$longAbndArr[$i] = number_format($rows[0] / 60) . ":0" . $rows[0] % 60;
} else {
$longAbndArr[$i] = number_format($rows[0] / 60) . ":" . $rows[0] % 60;
}
}
}
for ($i = 4; $i > 0; $i--) {
if (date("N") == 1) {
$lastMonday = mktime(0, 0, 0, date("m"), date("d"), date("y"));
$lastMonday -= 604800 * $i;
$lastFriday = $lastMonday + 431999;
$beginWk = date("Y-m-d", $lastMonday);
$endWk = date("Y-m-d", $lastFriday);
} else {
$lastMonday = strtotime("last Monday");
$lastMonday -= 604800 * $i;
$lastFriday = $lastMonday + 431999;
$beginWk = date("Y-m-d", $lastMonday);
$endWk = date("Y-m-d", $lastFriday);
}
$query = "\t\tSELECT\t\tmax(UNIX_TIMESTAMP(C.end)-UNIX_TIMESTAMP(C.start)) ";
$query .= "\t\tFROM\t\tusi_tbl_calllog as C";
$query .= "\t\tWHERE \tdcontext = 'Marwood_Day' ";
$query .= "\t\tAND\t\t\tstart BETWEEN '" . $beginWk . "' AND '" . $endWk . " 23:23:59'";
$query .= "\t\tAND\t\t\tdstchannel = '' ";
$query .= "\t\tAND \t\tsubstr(clid,12,8) <> 'asterisk' ";
$result = mysql_query($query) or die('Query failed: ' . mysql_info());
$rows = mysql_fetch_array($result, MYSQL_NUM);
if ($rows[0] == NULL) {
$longAbndArrWk[$i] = "0:00";
} else {
if ($rows[0] % 60 < 10) {
$longAbndArrWk[$i] = number_format($rows[0] / 60) . ":0" . $rows[0] % 60;
} else {
$longAbndArrWk[$i] = number_format($rows[0] / 60) . ":" . $rows[0] % 60;
}
}
}
// Insert Into Table
$query = "\t\tINSERT INTO `usi_misc`.`usi_marwood_call_tbl` \n\t\t\t\t\tVALUES (\n\t\t\t\t\t\t\t\t'" . date('Y-m-d') . "', \n\t\t\t\t\t\t\t\t" . $summary_id . ", \n\t\t\t\t\t\t\t\t'" . zeroIfNull($longAbndArr[1]) . "', \n\t\t\t\t\t\t\t\t'" . zeroIfNull($longAbndArr[2]) . "', \n\t\t\t\t\t\t\t\t'" . zeroIfNull($longAbndArr[3]) . "', \n\t\t\t\t\t\t\t\t'" . zeroIfNull($longAbndArr[4]) . "', \n\t\t\t\t\t\t\t\t'" . zeroIfNull($longAbndArr[5]) . "', \n\t\t\t\t\t\t\t\t'" . zeroIfNull($longAbndArr[6]) . "', \n\t\t\t\t\t\t\t\t'" . zeroIfNull($longAbndArr[7]) . "', \n\t\t\t\t\t\t\t\t'" . zeroIfNull($longAbndArr[8]) . "', \n\t\t\t\t\t\t\t\t'" . zeroIfNull($longAbndArr[9]) . "', \n\t\t\t\t\t\t\t\t'" . zeroIfNull($longAbndArr[10]) . "', \n\t\t\t\t\t\t\t\t'" . zeroIfNull($longAbndArr[11]) . "', \n\t\t\t\t\t\t\t\t'" . zeroIfNull($longAbndArr[12]) . "', \n\t\t\t\t\t\t\t\t'" . zeroIfNull($longAbndArrWk[4]) . "', \n\t\t\t\t\t\t\t\t'" . zeroIfNull($longAbndArrWk[3]) . "', \n\t\t\t\t\t\t\t\t'" . zeroIfNull($longAbndArrWk[2]) . "', \n\t\t\t\t\t\t\t\t'" . zeroIfNull($longAbndArrWk[1]) . "'\n\t\t\t\t\t\t\t);";
//echo $query;
$result = mysql_query($query) or die('Query failed: ' . mysql_info());
}
