<?php
/**
 * Created by PhpStorm.
 * User: PHP
 * Date: 2016/11/23
 * Time: 9:11
 */

class GetKennelDetailWorkCommand extends CConsoleCommand {
    public function run($args){
        //error_reporting(E_ERROR);
        ini_set('memory_limit', '256M');
        //ini_set('mongo.long_as_object',1);
        set_time_limit(0);
        self::getKennel();

    }

    public function getKennel()
    {
        $end_time = date("Y-m-d 13:59:59");
        $start_time = date("Y-m-d 14:00:00",strtotime("-1 day"));
        $criteria = new EMongoCriteria();
        $criteria->addCond('time','>=',strtotime(date('Y-m-d H:i:s',strtotime($start_time))));
        $criteria->addCond('time','<=',strtotime(date('Y-m-d H:i:s',strtotime($end_time))));
        $cursor = JRecord::model()->findAll($criteria);
        $rows = CommonFn::getRowsFromCursor($cursor);
        $parsedRows = JRecord::model()->parse($rows);

        $data = [];
        foreach ($parsedRows as &$row) {
            if ($row['type'] == 0) {
                $data[] = $row;
            }
        }
        if (count($data) == 0) {
            exit;
        }
        $type_name = 'food';
        $res=Service::factory('JRecordService')->push($data,$type_name,['start' => $start_time, 'end' => $end_time],1);
        $mail = Yii::app()->mailer;
        try {
            $mail->SMTPDebug = 2;                                 // Enable verbose debug output
            $mail->isSMTP();                                      // Set mailer to use SMTP
            $mail->Host = 'smtp.163.com';  // Specify main and backup SMTP servers
            $mail->SMTPAuth = true;                               // Enable SMTP authentication
            $mail->Username = 'insur_zhq1@163.com';                 // SMTP username
            $mail->Password = 'JgCoupon365';                           // SMTP password
            $mail->SMTPSecure = 'ssl';                            // Enable TLS encryption, `ssl` also accepted
            $mail->Port = 587;                                    // TCP port to connect to

            $mail->setFrom('insur_zhq1@163.com', 'JinGuo365');
            $mail->AddAddress('sh.zhq@163.com');
            $mail->AddAddress('511276154@qq.com');
            $mail->AddAddress('1340652578@qq.com');
            $mail->addAttachment(Yii::app()->basePath.'/export/'.$res);         // Add attachments

            $mail->isHTML(true);                                  // Set email format to HTML
            $mail->Subject = 'Pick up record'.date('Y-m-d');
            $mail->Body    = $res;
            $mail->AltBody = $res;

            $mail->send();
            echo 'Message has been sent';
        } catch (Exception $e) {
            echo 'Message could not be sent. Mailer Error: ', $mail->ErrorInfo;
        }

    }


}