<div class="row"> <div class="col-xs-2 ticket_icon"> <i class="fa fa-ticket fa-5x"></i> </div> <div class="col-xs-5"> <h2><?php echo CHtml::encode($model->ticket_title); ?> </h2> <div class="project_meta_details"> <?php $orderDetails = Orders::model()->findByAttributes(array("order_id" => $model->order_id)); $Total_amount = $orderDetails['currency'] . " " . $orderDetails['order_total']; $attrList = json_decode($orderDetails['order_Data']); $coupon_id = $orderDetails['coupon_id']; $couponDetails = Coupons::model()->findByAttributes(array("id" => $coupon_id)); $clientInfo = $attrList->userdata; $days = round($attrList->numofworkingday / 8); $fwdby = TicketAssign::model()->findByAttributes(array('ticket_id' => $ticket_id, 'fwd_to' => Yii::app()->session['user_data']['user_id'], 'status' => 1)); $fwd_name = ''; if (!empty($fwdby)) { $fwd_name = ucfirst(Users::model()->getUserName($fwdby->fwd_by)); } ?> <p>Client: <strong><a href=""></a> <?php echo ucfirst(Users::model()->getUserName($orderDetails['client_id'])); ?> </strong></p> <p>Priority: <strong><?php echo ucfirst($attrList->order->priority);
public function actionGetOrderlList() { $data = $_REQUEST['Coupons']; $result = array(); $newResult = array(); if (!empty($data['coupon_code'])) { $limit = 20; $page = $data['page']; $offset = ($page - 1) * $limit; $result = array(); $coupon_code = trim($data['coupon_code']); // $coupon_type = $data['coupon_type']; $validate_from = $data['validate_from']; $validate_to = $data['validate_to']; $Couponid = Coupons::model()->findByAttributes(array("coupon_code" => $coupon_code, "status" => 1)); if (!empty($Couponid['id'])) { if (!empty($validate_from)) { $orderTotal = count(Orders::model()->findAllByAttributes(array("coupon_id" => $Couponid['id']), array("condition" => "order_date >= '{$validate_from}' AND order_date <= '{$validate_to} 23:59:59'"))); $orderList = Orders::model()->findAllByAttributes(array("coupon_id" => $Couponid['id']), array("condition" => "order_date >= '{$validate_from}' AND order_date <= '{$validate_to} 23:59:59'", 'limit' => $limit, "offset" => $offset)); } else { $orderTotal = count(Orders::model()->findAllByAttributes(array("coupon_id" => $Couponid['id']))); $orderList = Orders::model()->findAllByAttributes(array("coupon_id" => $Couponid['id']), array('limit' => $limit, "offset" => $offset)); } } foreach ($orderList as $val) { $ticketid = Ticket::model()->findByAttributes(array("order_id" => $val['order_id'])); $result[] = array("order_id" => $val['order_id'], "url" => Yii::app()->createUrl("ticket/view", array("id" => base64_encode($ticketid['ticket_id']))), "client" => Users::model()->getUserName($val['client_id']), "amount" => $val['order_total'], "product_name" => $ticketid['ticket_title'], 'date' => date('d M Y @ g:i A', strtotime($val['order_date']))); } if (!empty($orderList)) { $newResult['pagination'] = $this->actionCreatePager($orderTotal, $limit, $page); $newResult['records'] = $result; } } echo json_encode($newResult); }