Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $dates = Array();
- $count = -1;
- $last_date = -1;
- $criteria = new CDbCriteria;
- $criteria->addBetweenCondition('date', date('Y-m-d', mktime(0, 0, 0, date("m") + 1, 1, date("Y") - 1)), date('Y-m-d'));
- $last_orders = Orders::model()->findAll($criteria);
- $orders_stats = Array();
- foreach($last_orders as $item) {
- $this_date = substr($item->date, 0, 7);
- if ($last_date == -1 || $this_date != $last_date) {
- $last_date = $this_date;
- $dates[++$count] = $this_date;
- $orders_stats[$count]++;
- } else {
- $orders_stats[$count]++;
- }
- }
- $criteria = new CDbCriteria;
- $criteria->addBetweenCondition('date', mktime(0, 0, 0, date("m") + 1, 1, date("Y") - 1), time());
- $last_phones = OrderPhone::model()->findAll($criteria);
- $phones_stats = Array();
- $count = -1;
- foreach($last_phones as $item) {
- $this_date = date('Y-m', $item->date);
- if (array_search($this_date, $dates) !== false) {
- $phones_stats[array_search($this_date, $dates)]++;
- }
- }
- $stats = "";
- for($i = 0; $i < count($dates); $i++)
- $stats .= "\t\t{d: '" . $dates[$i] . "', phones: " . $phones_stats[$i] . ", orders: " . $orders_stats[$i] . "}," . PHP_EOL;
- $managers_list = Managers::model()->findAll();
- $managers = array();
- foreach($managers_list as $item)
- $managers[$item->id] = array($item->id, $item->username, $item->family, $item->name, $item->otch);
- $managers_orders = Orders::model()->findAll();
- $managers_orders_stats = array();
- foreach($managers_orders as $item)
- {
- if ($item->manager_id > 0)
- {
- $managers_orders_stats[$item->manager_id]++;
- }
- }
- $managers_phones = OrderPhone::model()->findAll();
- $managers_phones_stats = array();
- foreach($managers_phones as $item)
- {
- if ($item->manager_id > 0)
- {
- $managers_phones_stats[$item->manager_id]++;
- }
- }
- $managers_all = "";
- foreach($managers as $item)
- {
- $this_phones = isset($managers_phones_stats[$item[0]]) ? $managers_phones_stats[$item[0]] : 0;
- $this_orders = isset($managers_orders_stats[$item[0]]) ? $managers_orders_stats[$item[0]] : 0;
- if ($this_phones > 0 || $this_orders > 0)
- $managers_all .= "\t\t{d: '" . $item[2] . " " . mb_substr($item[3], 0, 1, 'utf-8') . ". " . mb_substr($item[4], 0, 1, 'utf-8') . ".', phones: " . $this_phones . ", orders: " . $this_orders . "}," . PHP_EOL;
- }
- $this->render('index', array(
- 'stats'=>$stats,
- 'managers_all'=>$managers_all,
- ));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement