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>