public function loadModel($id)
{
$model = Ticket::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
public function actionadminHome()
{
/** @var User $username */
$username = Yii::app()->user->name;
$user = User::model()->find("username=:username", array(':username' => $username));
/* Get all tickets on the mentoring subsystem */
//$TicketsO = Ticket::model()->findAll("status=:pending" or "status=:reject",array(':pending'=>'pending', ':reject'=>'reject'));
$TicketsO = Ticket::model()->findAllBySql("SELECT * FROM ticket WHERE (status=:pending or status=:reject)", array(':pending' => 'pending', ':reject' => 'reject'));
$TicketsC = Ticket::model()->findAll("status=:status", array(':status' => 'close'));
//$TicketsR = Ticket::model()->findAll("status=:status",array(':status'=>'reject'));
$this->render('adminHome', array('TicketsO' => $TicketsO, 'TicketsC' => $TicketsC, 'user' => $user));
}
public function actionReply()
{
$model = new TicketMessage();
if (isset($_POST['TicketMessage'])) {
$model->attributes = $_POST['TicketMessage'];
if ($model->save()) {
//更新T状态is_answered:1
$t = Ticket::model()->findByPk($model->ticket_id);
$t->is_answered = 1;
$t->status = 'Staff-Reply';
$t->lastreply_time = date('Y-m-d H:i:s');
$t->save();
Yii::app()->user->setFlash('view-ticket', 'Your notes has been posted successfully.');
$this->redirect(array('ticket/view', 'id' => $model->ticket_id));
}
}
}
public function actionView($id)
{
$ticket = Ticket::model()->with('messages')->findByPk($id);
if (!$ticket) {
throw new CHttpException(404);
}
if ($ticket->client_id != Yii::app()->params['client_id']) {
throw new CHttpException(401);
}
$this->pageName = Yii::t('SupportModule.default', 'MODULE_NAME');
$modelForm = new TicketMessage();
if (Yii::app()->request->isPostRequest && $ticket->status != 0) {
$modelForm->attributes = $_POST['TicketMessage'];
$modelForm->ticket_id = $ticket->id;
$modelForm->user_id = Yii::app()->params['client_id'];
if ($modelForm->validate()) {
$modelForm->save(false);
Yii::app()->user->setFlash('success', Yii::t('app', 'SUCCESS_MSG_SAND'));
$this->refresh();
}
}
$this->render('view', array('model' => $ticket, 'modelForm' => $modelForm));
}
?>
</a>
<!-- <div style="margin-top = 0px; height: 300px; width: 1000px; overflow-y: scroll; border-radius: 5px;"> -->
<div id = "fullcontent"t>
<?php
$model1 = Ticket::model();
$MyTabs = array('tab1' => array('title' => "Open", 'content' => $this->widget('zii.widgets.grid.CGridView', array('id' => 'My_questions', 'dataProvider' => $model1->searchMyQuestions(User::getCurrentUserId()), 'columns' => array(array('name' => 'subject', 'value' => '$data->subject', 'htmlOptions' => array('width' => '120px')), array('name' => 'Last Activity', 'value' => '$data->getLatestActivityDate()', 'htmlOptions' => array('width' => '40px')), array('class' => 'CButtonColumn', 'template' => '{view}', 'buttons' => array('view' => array('url' => 'Yii::app()->createUrl("ticket/view", array("id"=>$data->id))'))))), true)), 'tab2' => array('title' => "Closed", 'content' => $this->widget('zii.widgets.grid.CGridView', array('id' => 'My_Closed_questions', 'dataProvider' => $model1->searchMyClosedQuestions(User::getCurrentUserId()), 'columns' => array(array('name' => 'subject', 'value' => '$data->subject', 'htmlOptions' => array('width' => '120px')), array('name' => 'Last Activity', 'value' => '$data->getLatestActivityDate()', 'htmlOptions' => array('width' => '40px')), array('class' => 'CButtonColumn', 'template' => '{view}', 'buttons' => array('view' => array('url' => 'Yii::app()->createUrl("ticket/view", array("id"=>$data->id))'))))), true)));
$this->widget('CTabView', array('tabs' => $MyTabs));
?>
<br/>
<?php
if (User::isCurrentUserDomMentor()) {
?>
<h3>Assigned Questions</h3> <br/>
<?php
$model3 = Ticket::model();
$AssignedTabs = array('tab4' => array('title' => "Open", 'content' => $this->widget('zii.widgets.grid.CGridView', array('id' => 'Assigned_tickets', 'dataProvider' => $model3->searchAssigned(User::getCurrentUserId()), 'columns' => array(array('name' => 'created_date', 'value' => '$data->getCreatedDateToString()'), 'subject', array('name' => 'Last Activity', 'value' => '$data->getLatestActivityDate()'), array('name' => 'Priority', 'value' => '$data->getPriorityString()'), array('class' => 'CButtonColumn', 'template' => '{view}', 'buttons' => array('view' => array('url' => 'Yii::app()->createUrl("ticket/view", array("id"=>$data->id))'))))), true)), 'tab3' => array('title' => "Closed", 'content' => $this->widget('zii.widgets.grid.CGridView', array('id' => 'Assigned_Closed_tickets', 'dataProvider' => $model3->searchAssignedClosed(User::getCurrentUserId()), 'columns' => array(array('name' => 'created_date', 'value' => '$data->getCreatedDateToString()'), 'subject', array('name' => 'Last Activity', 'value' => '$data->getLatestActivityDate()'), array('name' => 'Priority', 'value' => '$data->getPriorityString()'), array('class' => 'CButtonColumn', 'template' => '{view}', 'buttons' => array('view' => array('url' => 'Yii::app()->createUrl("ticket/view", array("id"=>$data->id))'))))), true)));
$this->widget('CTabView', array('tabs' => $AssignedTabs));
}
?>
<br/>
<h3>Upcoming Meetings</h3>
<?php
$model2 = VideoConference::model();
$this->widget('zii.widgets.grid.CGridView', array('id' => 'upcomingVc', 'dataProvider' => $model2->searchUpcoming(User::getCurrentUserId()), 'columns' => array('subject', array('name' => 'scheduled_for', 'value' => '$data->getDateToString()'), array('class' => 'CButtonColumn', 'template' => '{view}', 'buttons' => array('view' => array('url' => 'Yii::app()->createAbsoluteUrl("videoConference/join/".$data->id, array(), "https")'))))));
?>
<div class="span2" style="margin-left: 30px">
<!-- Cancel Button -->
<table>
<tr>
/**
* Get the number of tickets that are currently assigned to this queue.
*
* @return array
*/
public function getCurrentTicketCount()
{
$criteria = new \CDbCriteria();
$criteria->addCondition('queue_assignments.id = (select id from ' . TicketQueueAssignment::model()->tableName() . ' cass where cass.ticket_id = t.id order by cass.assignment_date desc limit 1) and queue_assignments.queue_id = :qid');
$criteria->params = array(':qid' => $this->id);
return Ticket::model()->with('queue_assignments')->count($criteria);
}
<tbody>
<tr>Your order information</tr>
<tr><h4>Event: <?php echo $event->title; ?></h4></tr>
<tr>
<table border="1" cellpadding="2" cellspacing="0" style="border-collapse:collapse" width="700">
<tbody>
<tr>
<td width="100">Ticket name</td>
<td width="100">Quantity</td>
<td width="100">Ticket type</td>
<td width="200">E-Ticket No. </td>
<td width="100">Price</td>
<td width="100">SubTotal</td>
</tr>
<?php foreach($orderItem as $item):?>
<?php $ticket = Ticket::model()->findByPk($item->ticket_id); ?>
<tr>
<td><?php echo $ticket->name; ?></td>
<td><?php echo $item->quantity; ?></td>
<td><?php if($ticket->eticket == 0)echo 'Paper ticket';else echo 'E-ticket';?></td>
<td><?php echo $item->enum?></td>
<td><?php echo $ticket->price; ?></td>
<td>£ <?php echo $ticket->price;?></td>
</tr>
<?php endforeach; ?>
<tr>
<td colspan="5" align="right">Delivery method: </td>
<td><?php
switch ($order->ship) {
case '1':
public function actiondomainMentorViewMeetings()
{
/** @var User $user */
$username = Yii::app()->user->name;
$user = User::model()->find("username=:username", array(':username' => $username));
$tickets = Ticket::model()->findAllBySql("select * from ticket where assign_user_id = {$user->id}");
$this->render('domainMentorViewMeetings', array('user' => $user, 'tickets' => $tickets));
}
public function checkStatus($id)
{
$data = Ticket::model()->count('ticket_status=' . $id);
return $data;
}
public static function escalateTicket($domain_id, $sub)
{
if ($sub) {
$userDomain = UserDomain::model()->findAllBySql("SELECT * FROM user_domain WHERE subdomain_id =:id", array(":id" => $domain_id));
$subdomain = Subdomain::model()->findByPk($domain_id);
$validator = $subdomain->validator;
} else {
$userDomain = UserDomain::model()->findAllBySql("SELECT * FROM user_domain WHERE domain_id =:id", array(":id" => $domain_id));
$domain = Domain::model()->findByPk($domain_id);
$validator = $domain->validator;
}
if ($userDomain != null && is_array($userDomain)) {
foreach ($userDomain as $auserDomain) {
/** @var UserDomain $auserDomain */
if ($auserDomain->tier_team == 2) {
if ($auserDomain->rate >= $validator) {
/*Query to the domain mentor to see how many tickets is allowed to be assigned */
$domainMentor = DomainMentor::model()->findAllBySql("SELECT * FROM domain_mentor WHERE user_id =:id", array(":id" => $auserDomain->user_id));
/** @var Ticket $count */
if (is_array($domainMentor)) {
foreach ($domainMentor as $adomainMentor) {
/** @var DomainMentor $adomainMentor */
$count = Ticket::model()->findBySql("SELECT COUNT(id) as `id` FROM ticket WHERE assign_user_id =:id", array(":id" => $adomainMentor->user_id));
if ($count->id < $adomainMentor->max_tickets) {
/*return the first available domain mentor on queue */
return $auserDomain->user_id;
}
}
}
}
}
}
}
return self::$admin;
/* Assign the ticket to the admin for reassign */
}
?>
/ticket?ts=5">
<div class="col-sm-3 link_to_Click">
<div class="circle-tile">
<div class="circle-tile-heading">
<i class="fa fa-ticket fa-fw fa-3x"></i>
</div>
<div class="circle-tile-content">
<div class="circle-tile-number">
<?php
if (!in_array(Yii::app()->session['user_data']['user_role_type'], array(0, 1, 2))) {
echo Ticket::model()->count('ticket_status==5 AND ticket_id IN (' . $tickList . ')');
} else {
echo Ticket::model()->count('ticket_status==5');
}
?>
</div>
<div class="circle-tile-description">
Closed Tickets
</div>
<!--<span class="circle-tile-footer">More Info <i class="fa fa-chevron-circle-right"></i></span>-->
</div>
</div>
</div>
</a>
<?php
}
?>
public function actionGetOrderlList()
{
$data = $_REQUEST;
$result = array();
$newResult = array();
if (!empty($data)) {
$limit = 20;
$page = $data['page'];
$offset = ($page - 1) * $limit;
$user_id = $data['Client'];
$category = $data['category'];
$status = $data['order_status'];
$start_date = $data['start_date'];
$end_date = $data['end_date'];
$condition = "";
if (!empty($start_date)) {
$condition = "created_date >= '{$start_date}' AND created_date <= '{$end_date} 23:59:59'";
}
if (!empty($category)) {
if (!empty($condition)) {
$condition .= " AND ";
}
$condition .= " ticket_title = '" . $category . "'";
}
if (!in_array(Yii::app()->session['user_data']['user_role_type'], array(0, 1, 2))) {
$ticketList = TicketAssign::model()->getTicketbyUser(Yii::app()->session['user_data']['user_id']);
$ticket_ids = array();
foreach ($ticketList as $ticket) {
$ticket_ids[] = $ticket['ticket_id'];
}
if (!empty($ticket_ids)) {
if (!empty($condition)) {
$condition .= " AND ";
}
$ticket_ids = implode($ticket_ids, ",");
$condition .= 'ticket_id in (' . $ticket_ids . ')';
} else {
if (!empty($condition)) {
$condition .= " AND ";
}
$condition .= 'ticket_id i=0';
}
if (!empty($condition)) {
$condition .= " AND ";
}
$condition .= "ticket_status != 1 ";
}
// echo $condition;die;
$orderTotal = count(Ticket::model()->findAllByAttributes(array(), array("condition" => $condition)));
$orderList = Ticket::model()->findAllByAttributes(array(), array("condition" => $condition, 'limit' => $limit, "offset" => $offset));
$count = 0;
foreach ($orderList as $val) {
if (!empty($user_id)) {
$orderDetails = Orders::model()->findByAttributes(array("order_id" => $val['order_id'], "client_id" => $user_id));
} else {
$orderDetails = Orders::model()->findByAttributes(array("order_id" => $val['order_id']));
}
$paymentD = json_decode($orderDetails['order_payment']);
if (!empty($orderDetails)) {
if (!empty($status)) {
if ($paymentD->payment_status == $status) {
$result[] = array("order_id" => $orderDetails['order_id'], "url" => Yii::app()->createUrl("ticket/view", array("id" => base64_encode($val['ticket_id']))), "client" => Users::model()->getUserName($orderDetails['client_id']), "amount" => $orderDetails['order_total'], "category" => $val['ticket_title'], "status" => $paymentD->payment_status, 'date' => date('d M Y @ g:i A', strtotime($val['created_date'])));
} else {
$count++;
}
} else {
$result[] = array("order_id" => $orderDetails['order_id'], "url" => Yii::app()->createUrl("ticket/view", array("id" => base64_encode($val['ticket_id']))), "client" => Users::model()->getUserName($orderDetails['client_id']), "amount" => $orderDetails['order_total'], "category" => $val['ticket_title'], "status" => $paymentD->payment_status, 'date' => date('d M Y @ g:i A', strtotime($val['created_date'])));
}
} else {
$count++;
}
}
if (!empty($orderList) && !empty($result)) {
$newResult['pagination'] = $this->actionCreatePager($orderTotal - $count, $limit, $page);
$newResult['records'] = $result;
}
}
echo json_encode($newResult);
}
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);
}
/**
* Displays a particular model.
* @param integer $id the ID of the model to be displayed
*/
public function actionView($id)
{
echo "<script>console.log('actionView!');</script>";
$model = $this->loadModel($id);
$promentor = ProjectMentor::model()->getProMentor($id);
$permentor = PersonalMentor::model()->getPerMentor($id);
$dommentor = DomainMentor::model()->getDomMentor($id);
$def = User::model()->findBySql("select * from user where username = '******'");
//$isactive = $model->activated;
if (isset($_POST['updateRoles'])) {
if ($model->isProMentor == 1) {
Project::model()->updateAll(array('project_mentor_user_id' => $def->id), 'project_mentor_user_id = ' . $model->id);
$promentor->max_hours = $_POST['pjmhours'];
$all = Project::model()->findAll();
$count = 0;
foreach ($all as $each) {
if (isset($_POST[$each->id . 'pjm'])) {
$p = Project::model()->findByPk($each->id);
$p->project_mentor_user_id = $model->id;
$p->save(false);
$count++;
}
}
$promentor->max_projects = $count;
$promentor->save();
}
if ($model->isDomMentor) {
UserDomain::model()->deleteAll("user_id = " . $model->id);
$dommentor->max_tickets = $_POST['dmmaxtickets'];
$dommentor->save();
$all = Domain::model()->findAll();
foreach ($all as $each) {
if (isset($_POST[$each->id])) {
$user_domain = new UserDomain();
$user_domain->user_id = $dommentor->user_id;
$user_domain->domain_id = $each->id;
$user_domain->active = 1;
$user_domain->save(false);
$allsubs = Subdomain::model()->findAllBySql("select * from subdomain where domain_id = {$each->id}");
if ($allsubs != null) {
foreach ($allsubs as $onesub) {
$temp = $onesub->id . 'ddmsub';
if (isset($_POST[$temp])) {
$user_domain = new UserDomain();
$user_domain->user_id = $dommentor->user_id;
$user_domain->domain_id = $each->id;
$user_domain->active = 1;
$rate = $each->id . '-' . $onesub->id . 'dmrate';
$tier = $each->id . '-' . $onesub->id . 'dmtier';
$user_domain->rate = $_POST[$rate];
$user_domain->tier_team = $_POST[$tier];
$user_domain->subdomain_id = $onesub->id;
$user_domain->save(false);
}
}
} else {
$user_domain = new UserDomain();
$user_domain->user_id = $dommentor->user_id;
$user_domain->domain_id = $each->id;
$user_domain->active = 1;
$user_domain->save(false);
}
}
}
}
if ($model->isPerMentor) {
Mentee::model()->updateAll(array('personal_mentor_user_id' => $def->id), 'personal_mentor_user_id = ' . $model->id);
$all = Mentee::model()->findAll();
$count = 0;
foreach ($all as $each) {
if (isset($_POST[$each->user_id . 'pm'])) {
//$p = Mentee::model()->findByPk($each->user_id);
$each->personal_mentor_user_id = $model->id;
$each->save(false);
$count++;
}
}
$permentor->max_hours = $_POST['pmhours'];
$permentor->max_mentees = $count;
$permentor->save();
}
/** @var User $username */
$projects = Project::model()->findAllBySql("SELECT title FROM project WHERE project_mentor_user_id={$id}");
$userdoms = UserDomain::model()->findAllBySql("SELECT distinct domain_id FROM user_domain WHERE user_id={$id}");
$Mentees = Mentee::model()->findAllBySql("SELECT user_id FROM mentee WHERE personal_mentor_user_id={$id}");
$Tickets = Ticket::model()->findAllBySql("SELECT * FROM ticket WHERE assign_user_id=:id", array(":id" => $id));
$this->render('view', array('Tickets' => $Tickets, 'model' => $model, 'userdoms' => $userdoms, 'Mentees' => $Mentees, 'projects' => $projects));
/*$this->render('view',array(
'model'=>$this->loadModel($id),
));*/
} else {
$projects = Project::model()->findAllBySql("SELECT title FROM project WHERE project_mentor_user_id={$id}");
$userdoms = UserDomain::model()->findAllBySql("SELECT distinct domain_id FROM user_domain WHERE user_id={$id}");
$Mentees = Mentee::model()->findAllBySql("SELECT user_id FROM mentee WHERE personal_mentor_user_id={$id}");
$Tickets = Ticket::model()->findAllBySql("SELECT * FROM ticket WHERE assign_user_id=:id", array(":id" => $id));
$this->render('view', array('Tickets' => $Tickets, 'model' => $model, 'userdoms' => $userdoms, 'Mentees' => $Mentees, 'projects' => $projects, 'model' => $this->loadModel($id)));
}
}
public function actioneditProfile()
{
/** @var User $username */
$username = Yii::app()->user->name;
$user = User::model()->find("username=:username", array(':username' => $username));
$projects = Project::model()->findAllBySql("SELECT title FROM project WHERE project_mentor_user_id IS NULL");
$userdoms = UserDomain::model()->findAllBySql("SELECT domain_id FROM user_domain WHERE user_id={$user->id}");
$Mentees = Mentee::model()->findAllBySql("SELECT user_id FROM mentee WHERE personal_mentor_user_id IS NULL");
$Tickets = Ticket::model()->findAllBySql("SELECT * FROM ticket WHERE assign_user_id=:id", array(":id" => $user->id));
$this->render('editProfile', array('Tickets' => $Tickets, 'user' => $user, 'userdoms' => $userdoms, 'Mentees' => $Mentees, 'projects' => $projects));
}
<?php
$this->pageTitle = Yii::app()->name . ' | View Ticket';
$result = Ticket::model()->findByAttributes(array("ticket_id" => $ticket_id, "read" => 0));
if (!empty($result)) {
$result->read = 1;
$result->read_by = Yii::app()->session['user_data']['user_id'];
$result->update();
}
?>
<!-- begin PAGE TITLE AREA -->
<div class="row">
<div class="col-lg-12">
<div class="page-title">
<h1><i class="fa fa-search"></i> View Ticket | <small><a class="text-blue" href="<?php
echo Yii::app()->createAbsoluteUrl('ticket/index');
?>
">Back to Listing</a></small></h1>
</div>
</div>
</div>
<!-- end PAGE TITLE AREA -->
<div class="row">
<div class="col-lg-12">
<div class="portlet portlet-default">
<div class="portlet-body">
<ul id="bookingTab" class="nav nav-tabs">
<li class="active" id='getTicketStatus'><a href="#ticket-view" data-toggle="tab"><i class="fa fa-search"></i> Overview</a></li>