Php Tag Question.

[The_broken]

Ok, this should be easy the php tag below works great for todays orders.

Is there a php tag that would show yesterdays order & so on.

Looking for one week or past 7 days.

<? $orders = get_total_orders_today(); echo $orders; ?>

Thanks
The_Broken
:rolleyes:

[LordShryku]

No way for us to answer this without seeing the code to your custom function get_total_orders_today()

[The_broken]

Hi LordShryku

Thanks for the reply. Well Here is the function code. See moderbill has a nice disply that shows order breakdowns by days ( week ) is there a way for me to do something like that.

// GET TOTAL NUMBER OF ORDERS TODAY (FOR STATISTICS)
function get_total_orders_today() {
$today=date("Y-m-d");
$db = new ps_DB;
$q = "SELECT order_id,order_amount FROM orders WHERE order_date='$today'";
$db->query($q);
$amount="";
$num = $db->num_rows();
while($db->next_record()) {
$total = $db->f("order_amount");
$amount = $total+$amount;
}
$ret - "<B>";
$ret .= $num;
$ret.= " </B>(";
$ret.= setup("currency");
$ret.= $amount;
$ret.= ") ";
return $ret;
}

[drawmack]

// GET TOTAL NUMBER OF ORDERS TODAY (FOR STATISTICS)
function get_daily_totals($days_ago = 0) {
    if(0 < $days_ago) {
        $timestamp = strtotime("-$days_ago days");
    } else {
        $timestamp = time();
    }
    $today=date("Y-m-d",$timestamp);
    $db = new ps_DB;
    $q  = "SELECT order_id,order_amount FROM orders WHERE order_date='$today'";
    $db->query($q);
    $amount="";
    $num = $db->num_rows();
    while($db->next_record()) {
        $total = $db->f("order_amount");
        $amount = $total+$amount;
    }
    $ret - "<B>";
    $ret .= $num;
    $ret.= " </B>(";
    $ret.= setup("currency");
    $ret.= $amount;
    $ret.= ") ";
    return $ret;
} //end get_daily_totals

[LordShryku]

You could very easily pass a variable to this function to subtract days from the date calculation. All you would need to do is change it just a bit....

function get_total_orders($sub) {
    //$sub is the amount of days to subtract
   $today=date("Y-m-d", mktime(0,0,0, date(m), date(d)-$sub, date(Y)));

//....the rest of the function can stay the same
}

// then to call it, say you wanted to subtract a week....
$orders = get_total_orders(7); //subtract 7 days

echo $orders;

[The_broken]

ok. I Don't under stand this LordShryku.

Where do I edit my old one. Also is there a way to display this by day. ( ie - monday, tuesday, wend, thur, friday, sat, sun)

This would give me a breakdown of how many orders came in on these day.

Thanks all for the help, not really good at php.

Thanks
The_broken
😕

[LordShryku]

Take drawmacks function. It's essentially the same thing I said. Yout call it with the number of days back you want to go

[The_broken]

Thanks LordShryku & drawmacks

One more quick question, your code does work great.

But can I also display the date. Right now it just pulls back the order like this:

0 ($)
1 ($533.8)
3 ($1301.4)
0 ($)
0 ($)
0 ($)

The first one being today and the last being 7 days ago.

Can it also pull back that day (ie mon-tues-wend-thur-fri-sat-sun)

Thanks for all your help.

I also notice your from pa, I am too dingmans.

The_broken
🆒

[LordShryku]

You should calculate the day outside of the function.

//assuming you know the date you're pulling for, in this example, yesterday
$date = "2003-09-26";
$day = date("D", strtotime($date));
echo $day

[The_broken]

// GET TOTAL NUMBER OF ORDERS TODAY (FOR STATISTICS)
function get_daily_totals($days_ago = 0) {
if(0 < $days_ago) {
$timestamp = strtotime("-$days_ago days");
} else {
$timestamp = time();
}
$today=date("Y-m-d",$timestamp);
$db = new ps_DB;
$q = "SELECT order_id,order_amount FROM orders WHERE order_date='$today'";
$db->query($q);
$amount="";
$num = $db->num_rows();
while($db->next_record()) {
$total = $db->f("order_amount");
$amount = $total+$amount;
}
$ret - "<B>";
$ret .= $num;
$ret.= " </B>(";
$ret.= setup("currency");
$ret.= $amount;
$ret.= ") ";
return $ret;
} //end get_daily_totals

Ok this new code works great. Now can I also pull back the date with this.

I have seven of the followings calling past 7 days. I only have to change (1) to get diffrent days. I would love to call back the date with it too.

<? $orders = get_daily_totals(1); echo $orders; ?>

All help welcome & thanks to all that have help me.

The_broken
😕

[drawmack]

Originally posted by The_broken
I also notice your from pa, I am too dingmans.

I'm in broadheadsville in the west end of the beautiful pocono mountains - well they would be beautiful if people would stop moving here.

[drawmack]

// GET TOTAL NUMBER OF ORDERS TODAY (FOR STATISTICS) 
function get_daily_totals($days_ago = 0) { 
//here we set timestamp to the timestamp for the day 
//we want.
if(0 < $days_ago) { 
$timestamp = strtotime("-$days_ago days"); 
} else { 
$timestamp = time(); 
} 

$today=date("Y-m-d",$timestamp); 
$db = new ps_DB; 
$q = "SELECT order_id,order_amount FROM orders WHERE order_date='$today'"; 
$db->query($q); 
$amount=""; 
$num = $db->num_rows(); 
while($db->next_record()) { 
$total = $db->f("order_amount"); 
$amount = $total+$amount; 
} 
//return the date
$ret  = "<b><u>";
$ret .= date("<format string>",$timestamp);
$ret .= "</u></b>";
$ret .= "<B>"; 
$ret .= $num; 
$ret.= " </B>("; 
$ret.= setup("currency"); 
$ret.= $amount; 
$ret.= ") "; 
return $ret; 
} //end get_daily_totals

see here to format your date string http://www.php.net/date