-
Notifications
You must be signed in to change notification settings - Fork 3
/
Copy pathcore.php
78 lines (56 loc) · 2.04 KB
/
core.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
<?php
header('Content-Type: text/plain');
ini_set('display_errors',true);
include('../app/Mage.php');
Mage::setIsDeveloperMode(true);
Mage::app(); //pass in store code if you like
date_default_timezone_set('Europe/London'); // add your locale - thanks to @benmarks from BlueAcorn for this
function getSoldCount($orders) {
$count = 0;
$number = count($orders);
return $number;
}
function getOrders($from,$to) {
$orders = Mage::getSingleton('sales/order')->getCollection()
->addAttributeToSelect('*')
->addFieldToFilter('created_at', array('from'=>$from, 'to'=>$to))
// ->addFieldToFilter('status', 'complete')
->addFieldToFilter('status', array('in' => array('complete','processing'))); // change these according to your biz
return $orders;
}
function countAtProcessing($from,$to) {
$orders = Mage::getSingleton('sales/order')->getCollection()
->addAttributeToSelect('*')
->addFieldToFilter('created_at', array('from'=>$from, 'to'=>$to))
->addFieldToFilter('status', 'processing');
// ->addFieldToFilter('status', array('in' => array('complete','processing')));
$num = count($orders);
return $num;
}
function countAtComplete($from,$to) {
$orders = Mage::getSingleton('sales/order')->getCollection()
->addAttributeToSelect('*')
->addFieldToFilter('created_at', array('from'=>$from, 'to'=>$to))
->addFieldToFilter('status', 'complete');
// ->addFieldToFilter('status', array('in' => array('complete','processing')));
$num = count($orders);
return $num;
}
function countAtClosed($from,$to) {
$orders = Mage::getSingleton('sales/order')->getCollection()
->addAttributeToSelect('*')
->addFieldToFilter('created_at', array('from'=>$from, 'to'=>$to))
->addFieldToFilter('status', 'closed');
// ->addFieldToFilter('status', array('in' => array('complete','processing')));
$num = count($orders);
return $num;
}
//excludes shipping amount
function getSoldValue($orders) {
$totalSales = 0;
foreach($orders as $order) {
$totalSales = $totalSales + $order->getGrandTotal() - $order->getShippingAmount();
}
return $totalSales;
}
?>