* 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()); }