if ($user->uid == 1 or $user->uid == 659) {

$count_sql = “SELECT COUNT(st.trans_id) as num FROM store_transaction as st, users as u WHERE u.uid = st.user_id AND st.payment_status = ‘Completed’ AND (u.state = ‘CO’ OR u.state = ‘colorado’) AND st.workflow = 2″;
$net_sql = “SELECT SUM(st.gross - st.fee) AS sum FROM store_transaction as st, users as u WHERE u.uid = st.user_id AND st.payment_status = ‘Completed’ AND (u.state = ‘CO’ OR u.state = ‘colorado’) AND st.workflow = 2″;
$gross_sql = “SELECT SUM(st.gross) AS sum FROM store_transaction as st, users as u WHERE u.uid = st.user_id AND st.payment_status = ‘Completed’ AND (u.state = ‘CO’ OR u.state = ‘colorado’) AND st.workflow = 2″;

$count = “

“.db_result(db_query($count_sql)).” transactions

“;
$profit = ‘

$’.number_format(db_result(db_query($gross_sql)), 2, ‘.’, ‘,’).’ gross, $’.number_format(db_result(db_query($net_sql)), 2, ‘.’, ‘,’).” net

“;

echo $count;
echo $profit;

$workflow = store_invoice_workflow();
$wf_colors = store_invoice_workflow_colors();
$sql = “(SELECT COUNT(pl.quantity) AS num_prod, u.first_name, u.last_name, u.uid as uid, u.state, pl.trans_id, st.dt_added as ordered_on, st.dt_shipped as shipped_on, st.workflow, st.gross, st.fee
FROM store_trans_prod_lookup AS pl, store_tangible_prod AS tp, store_product AS sp, store_transaction AS st, users AS u
WHERE sp.prod_type != ‘file’
AND st.trans_id = pl.trans_id
AND u.uid = st.user_id
AND pl.prod_id = sp.prod_id
AND tp.prod_id = pl.prod_id
AND st.payment_status = ‘Completed’
AND (u.state = ‘CO’ OR u.state = ‘colorado’)
AND st.workflow = 2
GROUP BY pl.trans_id)
UNION
(SELECT COUNT(pl.quantity) AS num_prod, u.first_name, u.last_name, u.uid as uid, u.country, pl.trans_id, st.dt_added as ordered_on, st.dt_shipped as shipped_on, st.workflow, st.gross, st.fee
FROM store_trans_prod_lookup AS pl, store_multi_prod AS mp, store_product AS sp, store_transaction AS st, users AS u
WHERE st.trans_id = pl.trans_id
AND u.uid = st.user_id
AND pl.prod_id = mp.prod_id
AND mp.sub_prod_id = sp.prod_id
AND sp.prod_type != ‘file’
AND st.payment_status = ‘Completed’
AND (u.state = ‘CO’ OR u.state = ‘colorado’)
AND st.workflow = 2
GROUP BY mp.sub_prod_id)”;
$header = array(
array (”data” => t(”ID”), “field” => “pl.trans_id”),
array (”data” => t(”User”), “field” => “last_name”),
array (”data” => t(”State”), “field” => “u.state”),
array (”data” => t(”Num Items”), “field” => “num_prod”),
array (”data” => t(”Ordered On”), “field” => “ordered_on”, “sort” => “desc”),
array (”data” => t(”Total”), “field” => “st.gross”),
array (”data” => t(”Status”), “field” => “st.workflow”),
t(”action”)
);
$sql .= tablesort_sql($header);
$result = pager_query($sql, 50);

while ($data = db_fetch_object($result)) {
if ($data->shipped_on == “0000-00-00 00:00:00″ and $workflow[$data->workflow] != “Canceled” or $workflow[$data->workflow] != “Shipped”) {
$shipped_on = “Not Shipped
[trans_id\”>Ship Now]”;
} else {
$shipped_on = date(”D, M j - g:i a”, strtotime($data->shipped_on));
}
$ordered_on = date(”D, M j - g:i a”, strtotime($data->ordered_on));

$name = ucwords(strtolower($data->first_name)).” “.ucwords(strtolower($data->last_name));
$name = array(”data” => $name, “nowrap” => “nowrap”);
//$country = ($data->country == “United States”) ? $data->country : array(”data” => $data->country, “bgcolor” => “#cccccc”);
$rows[] = array($data->trans_id, $name, $data->state, array(”data” => $data->num_prod, “align” => “middle”), $ordered_on, $data->gross, array(”data” => $workflow[$data->workflow], “bgcolor” => $wf_colors[$data->workflow]), l(t(”edit”), “admin/store/invoice/edit/$data->trans_id”).” / “.l(t(”print”), “store/invoice/print/$data->trans_id”));
}

$pager = pager_display(NULL, 50, 0, “admin”, tablesort_pager());
if (!empty($pager)) {
$rows[] = array(array(”data” => $pager, “colspan” => 7));
}
echo table($header, $rows);

} else {
message_access();
}
?>