public function send()
{
$clang = Yii::app()->lang;
if (!Permission::model()->hasGlobalPermission('panellist', 'create')) {
Yii::app()->setFlashMessage($clang->gT("You do not have sufficient rights to access this page."), 'error');
$this->getController()->redirect(array("admin/index"));
}
$action = isset($_POST['action']) ? $_POST['action'] : '';
$project_id = isset($_GET['prjid']) ? $_GET['prjid'] : '';
$aData['prjid'] = $project_id;
$vid = isset($_GET['vid']) ? $_GET['vid'] : '';
$aData['vid'] = $vid;
if ($action == "Send") {
$query_id = (int) Yii::app()->request->getPost("query_id");
$project_id = (int) Yii::app()->request->getPost("project_id");
$stack = " LIMIT " . (int) Yii::app()->request->getPost("stack");
$getpids = GetPanellistIDsForSend($query_id, $project_id, $action, $stack);
$user_id = Yii::app()->user->id;
$created_date = Date('y-m-d h:i:s');
$send_date = Date('y-m-d h:i:s');
$sid = getmaxsendid() + 1;
$subjectid = 1;
//$template_id = 1;
$template_id = EMAIL_POINT_QueryPullSend;
$is_send = 1;
foreach ($getpids as $key) {
$pid = (int) $key['panellist_id'];
$sql_insert = "insert into {{query_send_details}} (send_id,query_id,project_id,subjectt_id,template_id,panellist_id,send,userid,created_date,send_date) values\n ({$sid},{$query_id},{$project_id},{$subjectid},{$template_id},{$pid}, {$is_send},{$user_id},'{$created_date}','{$send_date}')";
$rString = Yii::app()->db->createCommand($sql_insert)->execute();
}
$msg = $clang->gT('Send was queued successfully');
$msg .= '<br/>';
$msg .= $clang->gT('Invitations shall be send on next cron execute');
Yii::app()->setFlashMessage($msg);
// if pid vid condition
if ($_POST['pid'] != '' && $_POST['vid'] != '') {
$pid = $_POST['pid'];
$vid = $_POST['vid'];
//echo '<script>$.fancybox.close()</script>;';
$this->getController()->redirect(array("admin/project/sa/modifyproject/project_id/{$pid}/action/modifyvendor/vid/{$vid}"));
} else {
$this->getController()->redirect(array("admin/pquery/index"));
}
}
if ($action == "Resend") {
$query_id = (int) Yii::app()->request->getPost("query_id");
$project_id = (int) Yii::app()->request->getPost("project_id");
$stack = " LIMIT " . (int) Yii::app()->request->getPost("stack");
$getpids = GetPanellistIDsForSend($query_id, $project_id, $action, $stack);
$user_id = Yii::app()->user->id;
$created_date = Date('y-m-d h:i:s');
$send_date = Date('y-m-d h:i:s');
$subjectid = 1;
$template_id = EMAIL_POINT_QueryPullSend;
$is_send = 0;
foreach ($getpids as $key) {
$pid = (int) $key['panellist_id'];
$sql_insert = "update {{query_send_details}} \n set reminder = 1,\n status = 0\n where project_id = {$project_id} \n and panellist_id = {$pid}";
$rString = Yii::app()->db->createCommand($sql_insert)->execute();
}
Yii::app()->setFlashMessage($clang->gT("Reminder was queued successfully"));
if ($_POST['pid'] != '' && $_POST['vid'] != '') {
$pid = $_POST['pid'];
$vid = $_POST['vid'];
//echo '<script>$.fancybox.close()</script>;';
$this->getController()->redirect(array("admin/project/sa/modifyproject/project_id/{$pid}/action/modifyvendor/vid/{$vid}"));
} else {
$this->getController()->redirect(array("admin/pquery/index"));
}
}
$aData['row'] = 0;
$aData['query_id'] = $_REQUEST['id'];
$aData['project_id'] = $_REQUEST['prjid'];
$aData['query_name'] = $_REQUEST['qname'];
if (isset($_REQUEST['resend'])) {
$aData['type'] = 'Resend';
} else {
$aData['type'] = 'Send';
}
//echo $_REQUEST['id'];exit();
$aData['imageurl'] = Yii::app()->getConfig("adminimageurl");
$aData['clang'] = $clang = Yii::app()->lang;
$aData['sImageURL'] = Yii::app()->getConfig('adminimageurl');
//popup
if (Yii::app()->request->isAjaxRequest) {
Yii::app()->getController()->renderPartial('/admin/panellist/query/' . 'send_query', $aData);
}
}
<?php
$project = Project::model()->findAllByPk($project_id);
$st = 0;
if ($project[0]['project_status_id'] == getGlobalSetting('project_status_hold')) {
$st = 1;
}
?>
<div class='header ui-widget-header'>
<?php
$clang->eT($type . ' Query : ' . $query_name . ' [' . $query_id . '] ' . ' For Project :' . $project[0]['project_name'] . ' [' . $project_id . ']');
?>
</div>
<br />
<?php
echo CHtml::form(array("admin/pquery/sa/send"), 'post', array('class' => 'form30', 'id' => 'sqlqueryform', 'enctype' => 'multipart/form-data'));
$total_r = count(GetPanellistIDsForSend($query_id, $project_id, $type));
?>
N : <input type="text" name="stack" id="stack" required>
<input type="hidden" value="<?php
echo $total_r;
?>
" name="total_r" id="total_r"> Balance:
<input type="hidden" value="<?php
echo $st;
?>
" name="st" id="st"/>
<span id="dispr" class="trues"><?php
echo $total_r;
?>
</span>
