Exemplo n.º 1
0
 public function init()
 {
     $this->addHeader(['attributes' => array(), 'options' => array(), 'columns' => array(array('name' => 'id', 'content' => 'ID'), array('name' => 'fullName', 'content' => 'Họ tên'), array('name' => 'email', 'content' => 'Email'), array('name' => 'description', 'content' => 'Mô tả'), array('name' => 'birthdate', 'content' => 'Ngày sinh'), array('name' => 'createdDateTime', 'content' => 'Ngày đăng kí'))]);
     if (!is_array($this->getDataSource()) && !$this->getDataSource() instanceof \Zend\Paginator\Paginator) {
         return;
     }
     if ($this->getDataSource() > 0) {
         /** @var  $item \Expert\Model\Expert */
         foreach ($this->getDataSource() as $item) {
             $row = new Row();
             $this->addRow($row);
             // Add $item to row
             $row->addColumn(array('name' => 'id', 'content' => $item->getId(), 'attributes' => []));
             // name
             $row->addColumn(array('name' => 'name', 'content' => $item->getFullName(), 'attributes' => []));
             $row->addColumn(array('name' => 'email', 'content' => $item->getEmail(), 'attributes' => []));
             $row->addColumn(array('name' => 'description', 'content' => $item->getDescription(), 'attributes' => []));
             $row->addColumn(array('name' => 'birthdate', 'content' => DateBase::toDisplayDate($item->getBirthdate()), 'attributes' => []));
             // Status
             //                if($item->getStatus()==1){
             //                    $status = '<i style="color:green;font-size:14px;" class="fa fa-check-circle"></i>';
             //                }else{
             //                    $status = '<div class="label label-warning">Khóa</div>';
             //                }
             $row->addColumn(array('name' => 'createdDateTime', 'content' => DateBase::toDisplayDateTime($item->getCreatedDateTime()), 'attributes' => ['style' => 'position: relative']));
         }
     }
 }
Exemplo n.º 2
0
 /**
  * @param $mess \Admin\Model\MessagesMG
  */
 public function reportdetail($mess)
 {
     $dm = $this->getServiceLocator()->get('doctrine.documentmanager.odm_default');
     $select = $this->getDbSql()->select(['ca' => self::TABLE_NAME]);
     $predicateSet = new PredicateSet();
     $predicateSet->addPredicate(new Operator('ca.callcenter', Operator::OPERATOR_EQUAL_TO, $mess->getSender()), $predicateSet::OP_OR);
     $predicateSet->addPredicate(new Operator('ca.mentor', Operator::OPERATOR_EQUAL_TO, $mess->getSender()), $predicateSet::OP_OR);
     $select->where($predicateSet);
     $select->where(['ca.endedDate' => DateBase::toCommonDate($mess->getCreated())]);
     $query = $this->getDbSql()->buildSqlString($select);
     $rows = $this->getDbAdapter()->query($query, Adapter::QUERY_MODE_EXECUTE);
     $result = [];
     $time = '';
     foreach ($rows as $r) {
         $result[DateBase::toDisplayDateTime($r['createdDateTime']) . ' - ' . DateBase::toDisplayDateTime($r['endedDateTime'])] = ['rating' => $r['rating'], 'comment' => $r['note']];
         $createdDatetime = new \DateTime($r['createdDateTime']);
         $endDatetime = new \DateTime($r['endedDateTime']);
         $timediff = date_diff($createdDatetime, $endDatetime);
         $result[DateBase::toDisplayDateTime($r['createdDateTime']) . ' - ' . DateBase::toDisplayDateTime($r['endedDateTime'])]['time'] += $timediff->format('%i');
         $qb = $dm->createQueryBuilder('Admin\\Model\\MessagesMG');
         $qb->field('receiver')->equals($r['room']);
         $qb->field('created')->range($createdDatetime, $endDatetime);
         $querymg = $qb->getQuery();
         $resultmg = $querymg->execute();
         $i = 0;
         /** @var \Admin\Model\MessagesMG $m */
         foreach ($resultmg as $m) {
             $i++;
             $result[DateBase::toDisplayDateTime($r['createdDateTime']) . ' - ' . DateBase::toDisplayDateTime($r['endedDateTime'])]['messages'][] = ['sender' => $m->getSender(), 'room' => $m->getReceiver(), 'msg' => $m->getMsg(), 'imgPath' => $m->getImgPath(), 'created' => $m->getCreated()->format(DateBase::DISPLAY_DATETIME_FORMAT)];
             //                vdump($i.'. Sender: '.$m->getSender().'|| Receiver: '.$m->getReceiver().' || Msg: '.$m->getMsg().' || Created: '.$m->getCreated()->format(DateBase::DISPLAY_DATETIME_FORMAT));
         }
     }
     return $result;
     //        if($mess->getSender()){
     //            $qb->field('sender')->equals($mess->getSender());
     //        }
 }
Exemplo n.º 3
0
 /**
  */
 public function init()
 {
     $loginUserId = $this->getOption('loginUserId');
     $this->setAttributes(array('id' => 'dgTransaction'));
     $this->addHeader(array('columns' => array(array('name' => 'id', 'content' => 'ID'), array('name' => 'company', 'content' => 'Công ty'), array('name' => 'applyDate', 'content' => 'Ngày hạch toán'), array('name' => 'type', 'content' => 'Loại phiếu'), array('name' => 'totalItems', 'content' => 'Số hạng mục'), array('name' => 'valueBeforeTax', 'content' => 'Giá trị'), array('name' => 'createdBy', 'content' => 'Người tạo'), array('name' => 'approveBy', 'content' => 'Duyệt'), array('name' => 'accountingBy', 'content' => 'Hạch toán'), array('name' => 'action', 'content' => '<i class="fa fa-edit icon"></i>'))));
     if (!$this->getDataSource() instanceof \Zend\Paginator\Paginator || !$this->getDataSource()->getCurrentModels()) {
         return;
     }
     foreach ($this->getDataSource()->getCurrentModels() as $transaction) {
         /*@var $transaction \Accounting\Model\Transaction */
         $row = new Row();
         $this->addRow($row);
         $row->addColumn(array('name' => 'id', 'content' => $transaction->getId()));
         $row->addColumn(array('name' => 'company', 'content' => $transaction->getOption('companyName')));
         $row->addColumn(array('name' => 'applyDate', 'content' => DateBase::toDisplayDate($transaction->getApplyDate())));
         $content = '';
         if ($transaction->getType() == \Accounting\Model\Transaction::TYPE_PAYMENT) {
             $content = '<b class="text-danger">' . $transaction->getTypeName() . '</b>';
         } else {
             $content = '<b class="text-info">' . $transaction->getTypeName() . '</b>';
         }
         $row->addColumn(array('name' => 'type', 'content' => $content));
         $row->addColumn(array('name' => 'totalItem', 'content' => $transaction->getOption('totalItems'), 'attributes' => ['class' => 'colNumber']));
         $row->addColumn(array('name' => 'valueBeforeTax', 'content' => \Home\Model\Format::toNumber($transaction->getOption('valueBeforeTax')), 'attributes' => ['class' => 'colNumber']));
         $content = [];
         if ($transaction->getOption('createdBy')) {
             $content[] = '<div>' . ($transaction->getOption('createdBy')->getFullName() ?: $transaction->getOption('createdBy')->getEmail()) . '</div>';
         }
         $content[] = '<div><i class="date">' . DateBase::toDisplayDateTime($transaction->getCreatedDateTime()) . '</i></div>';
         $row->addColumn(array('name' => 'createdBy', 'content' => implode('', $content)));
         $content = [];
         if ($transaction->getApprovedById()) {
             if ($transaction->getStatus() == \Accounting\Model\Transaction::STATUS_APPROVED) {
                 if ($transaction->getOption('approvedBy')) {
                     $content[] = '<div class="text-success"><b>Duyệt: </b>' . ($transaction->getOption('approvedBy')->getFullName() ?: $transaction->getOption('approvedBy')->getEmail()) . '</div>';
                 }
                 if ($transaction->getApprovedDateTime()) {
                     $content[] = '<div class="text-success"><i class="date">' . DateBase::toDisplayDateTime($transaction->getApprovedDateTime()) . '</i></div>';
                 }
                 $content[] = '<a href="/accounting/transaction/approvereq?id=' . $transaction->getId() . '">Hủy duyệt</a>';
             } elseif ($transaction->getStatus() == \Accounting\Model\Transaction::STATUS_INAPPROVED) {
                 if ($transaction->getOption('approvedBy')) {
                     $content[] = '<div class="text-danger"><b>Hủy: </b>' . ($transaction->getOption('approvedBy')->getFullName() ?: $transaction->getOption('approvedBy')->getEmail()) . '</div>';
                 }
                 if ($transaction->getApprovedDateTime()) {
                     $content[] = '<div class="text-danger"><i class="date">' . DateBase::toDisplayDateTime($transaction->getApprovedDateTime()) . '</i></div>';
                 }
                 $content[] = '<a href="/accounting/transaction/approvereq?id=' . $transaction->getId() . '">Duyệt</a>';
             } else {
                 if ($transaction->getOption('approvedBy')) {
                     $content[] = '<div class="text-success"><b>Duyệt: </b>' . ($transaction->getOption('approvedBy')->getFullName() ?: $transaction->getOption('approvedBy')->getEmail()) . '</div>';
                 }
                 if ($transaction->getApprovedDateTime()) {
                     $content[] = '<div class="text-success"><i class="date">' . DateBase::toDisplayDateTime($transaction->getApprovedDateTime()) . '</i></div>';
                 }
             }
         } else {
             $content[] = '<a href="/accounting/transaction/approvereq?id=' . $transaction->getId() . '">Duyệt</a>';
         }
         $row->addColumn(array('name' => 'approvedBy', 'content' => implode('', $content), 'attributes' => ['class' => 'colControls']));
         $content = [];
         if ($transaction->getAccountingById()) {
             if ($transaction->getOption('accountingBy')) {
                 $content[] = '<div>' . ($transaction->getOption('accountingBy')->getFullName() ?: $transaction->getOption('accountingBy')->getEmail()) . '</div>';
             }
             if ($transaction->getAccountingDateTime()) {
                 $content[] = '<div><i class="date">' . DateBase::toDisplayDateTime($transaction->getAccountingDateTime()) . '</i></div>';
             }
         } else {
             $content[] = '<a href="/accounting/transaction/accountingreq?id=' . $transaction->getId() . '">Duyệt</a>';
         }
         $row->addColumn(array('name' => 'accountingBy', 'content' => implode('', $content), 'attributes' => ['class' => 'colControls']));
         /** @todo: đang đợi chỉ thị để làm nốt
             $content = [];
             if($transaction->getPaymentById()){
                 if($transaction->getOption('paymentBy')){
                     $content[] = '<div>'.($transaction->getOption('paymentBy')->getFullName()
                         ?:$transaction->getOption('paymentBy')->getEmail()).'</div>';
                 }
                 if($transaction->getPaymentDateTime()){
                     $content[] = '<div><i class="date">'.DateBase::toDisplayDateTime($transaction->getPaymentDateTime()).'</i></div>';
                 }
             } else {
                 $content[] = '<a href="/accounting/transaction/payment?id='.$transaction->getId().'">Duyệt</a>';
             }
             $row->addColumn(array(
                 'name' => 'paymentBy',
                 'content' => implode('', $content),
                 'attributes' => ['class' => 'colControls']
             )); */
         $content = [];
         if ($transaction->getStatus() == \Accounting\Model\Transaction::STATUS_NEW) {
             if ($transaction->getCreatedById() == $loginUserId) {
                 $content[] = '<a class="fa fa-edit icon" href="/accounting/transaction/editreq?id=' . $transaction->getId() . '"></a>';
             }
         }
         $row->addColumn(array('name' => 'action', 'content' => implode('', $content), 'attributes' => ['class' => 'colControls']));
     }
 }