function is_user()
{
$valid = sql::count('admin', "admin_email='{$_POST['email']}'");
if ($valid > 0) {
return TRUE;
} else {
$this->form_validation->set_message('is_user', 'Email is invalid!');
return FALSE;
}
}
function get_user_grid()
{
$sortname = common::getVar('sidx', 'id');
$sortorder = common::getVar('sord', 'asc');
$sort = "ORDER BY {$sortname} {$sortorder}";
$searchField = common::getVar('searchField');
$searchValue = common::getVar('searchValue');
$con = 1;
if ($searchField != '' && $searchValue != '') {
$con .= " and {$searchField} like '%{$searchValue}%'";
}
$sql = "select * from scic_user where {$con} {$sort}";
$page = common::getVar('page', 1);
$limit = common::getVar('rows');
$count = sql::count("scic_user");
if ($count > 0) {
$total_pages = ceil($count / $limit);
} else {
$total_pages = 0;
}
if ($page > $total_pages) {
$page = $total_pages;
}
if ($limit < 0) {
$limit = 0;
}
$start = $limit * $page - $limit;
if ($start < 0) {
$start = 0;
}
$sql_query = $this->db->query($sql . " limit {$start}, {$limit}");
$rows = $sql_query->result_array();
$i = 0;
$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count;
foreach ($rows as $row) {
$status = $row[status] == 'active' ? 'Active' : 'Inactive';
$responce->rows[$i]['id'] = $row['id'];
$responce->rows[$i]['cell'] = array($row['username'], $row['password'], $status);
//$row['first_name'] . ' ' . $row['last_name'], $row['email'],
$i++;
}
header("Expires: Sat, 17 Jul 2010 05:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . "GMT");
header("Cache-Control: no-cache, must-revalidate");
header("Pragma: no-cache");
header("Author: Mohaimen khan");
header("Email: joyes528@gmail.com");
header("Content-type: text/x-json");
echo json_encode($responce);
return '';
}
function get_shorturl_grid()
{
$sortname = common::getVar('sidx', 'id');
$sortorder = common::getVar('sord', 'desc');
$sort = "ORDER BY {$sortname} {$sortorder}";
$serachoption = '1 ';
if ($this->session->userdata('purchase_search') != '') {
$serachoption = $this->session->userdata('purchase_search');
//$this->session->unset_userdata('purchase_search');
}
$sql = "select * from urls where " . $serachoption . $sort;
$page = common::getVar('page', 1);
$limit = common::getVar('rows');
$i = 0;
$count = sql::count('urls', '1');
if ($count > 0) {
$total_pages = ceil($count / $limit);
} else {
$total_pages = 5;
}
if ($page > $total_pages) {
$page = $total_pages;
}
if ($limit < 0) {
$limit = 0;
}
$start = $limit * $page - $limit;
if ($start < 0) {
$start = 0;
}
$sql_query = $this->db->query($sql . " limit {$start}, {$limit}");
$rows = $sql_query->result_array();
$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count;
foreach ($rows as $row) {
$surl = "guit.biz/" . $row['shortcode'];
$responce->rows[$i]['id'] = $row['id'];
$responce->rows[$i]['cell'] = array($row['shortcode'], $surl, $row['url'], $row['ga_campaign'], $row['ga_adgroup'], $row['ga_ad_content'], $row['ga_keyword']);
$i++;
}
header("Expires: Sat, 17 Jul 2010 05:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . "GMT");
header("Cache-Control: no-cache, must-revalidate");
header("Pragma: no-cache");
header("Author:Mohaimen khan");
header("Email: joyes@sec.ac.bd");
header("Content-type: text/x-json");
echo json_encode($responce);
return '';
}
function sendEmail($id)
{
// parameters of your mail server and how to send your email
$config = array('protocol' => 'smtp', 'smtp_host' => 'ssl://smtp.googlemail.com', 'smtp_port' => 465, 'smtp_user' => '*****@*****.**', 'smtp_pass' => 'testpasswdxxx', 'mailtype' => 'html');
$data = sql::row("scic_result", "user_id={$id}");
$count = sql::count("scic_question", "type='1' and status='active'");
$mul_marks = $data['first_part'] / $count * 100;
$count = sql::count("scic_question", "type='1' and status='active'");
$count_mth = sql::count("scic_question", "type='2' and status='active'");
$math_marks = $data['second_part'] / $count_mth * 100;
$name = sql::row("scic_skillset", "user_id={$id}");
$t_tme = common::time_diff($name['left_time'], $name['arrival_time']);
$sql = "SELECT * FROM scic_general,scic_question WHERE user_id={$id} and id=ans_number and scic_general.type='0' and scic_question.type='0'";
$query = $this->db->query($sql, array($type));
$result = $query->result_array();
// recipient, sender, subject, and you message
$to = "*****@*****.**";
$from = "*****@*****.**";
$subject = "Test Result::" . $name['fullname'];
$message = "Candidate Name: " . $name['fullname'] . "</br> Candidate Email: " . $data['email'] . "</br> Marks in General: " . $data['general'] . "</br> Marks in first part:" . $mul_marks . " Percent(" . $data['first_part'] . " right answer among " . $count . " problems) </br> Marks in Second Part:" . $math_marks . " Percent(" . $data['second_part'] . " right answer among " . $count_mth . " problems) </br> Marks in Third Part: " . $data['third_part'] . "</br> Total Time Taken: " . $t_tme . " Seconds </br> </br>";
$message .= "****<strong><u>Test Details::General Section</u></strong>**** </br>";
foreach ($result as $row) {
$message .= "<strong>" . $row['texts'] . "</strong></br><strong><u>Ans: </u></strong>" . $row['answer'] . "</br>";
}
$sql = "SELECT texts,scic_part_i.answer as given_answer,scic_answer.answer as org_answer,first,second,third,fourth FROM scic_part_i,scic_question,scic_multi_ans,scic_answer WHERE scic_part_i.user_id={$id} and scic_question.id=scic_part_i.ans_number and scic_answer.ans_number=scic_part_i.ans_number and scic_answer.type='1' and scic_part_i.type=scic_question.type and scic_multi_ans.qid=scic_part_i.ans_number";
$query = $this->db->query($sql, array($type));
$result = $query->result_array();
$message .= "</br>****<strong><u>Test Details::Multiple Choice Section</u></strong>**** </br>";
foreach ($result as $row) {
if ($row['given_answer'] == "a") {
$mul = $row['first'];
if ($row['given_answer'] != $row['org_answer']) {
$mul = $mul . "(<font color='red'>Wrong Answer</font>)";
}
} else {
if ($row['given_answer'] == "b") {
$mul = $row['second'];
if ($row['given_answer'] != $row['org_answer']) {
$mul = $mul . "(<font color='red'>Wrong Answer</font>)";
}
} else {
if ($row['given_answer'] == "c") {
$mul = $row['third'];
if ($row['given_answer'] != $row['org_answer']) {
$mul = $mul . "(<font color='red'>Wrong Answer</font>)";
}
} else {
if ($row['given_answer'] == "d") {
$mul = $row['fourth'];
if ($row['given_answer'] != $row['org_answer']) {
$mul = $mul . "(<font color='red'>Wrong Answer</font>)";
}
} else {
$mul = "None(<font color='red'>Wrong Answer</font>)";
}
}
}
}
$message .= "<strong>" . $row['texts'] . "</strong></br><strong><u>Ans: </u></strong>" . $mul . "</br>";
}
$sql = "SELECT texts,scic_part_ii.answer as given_answer,scic_answer.answer as org_answer FROM scic_part_ii,scic_question,scic_answer WHERE scic_part_ii.user_id={$id} and scic_question.id=scic_part_ii.ans_number and scic_part_ii.type=scic_question.type and scic_answer.type='2' and scic_answer.ans_number=scic_part_ii.ans_number";
$query = $this->db->query($sql, array($type));
$result = $query->result_array();
$message .= "</br>****<strong><u>Test Details::Math Section</u></strong>**** </br>";
foreach ($result as $row) {
if ($row['given_answer'] != $row['org_answer']) {
$mul = $row['given_answer'] . "(<font color='red'>Wrong Answer</font>)";
} else {
$mul = $row['given_answer'];
}
//"None(<font color='red'>Wrong Answer</font>)";
$message .= "<strong>" . $row['texts'] . "</strong></br><strong><u>Ans: </u></strong>" . $mul . "</br>";
}
$sql = "SELECT * FROM scic_part_iii,scic_question WHERE user_id={$id} and id=ans_number and scic_part_iii.type=scic_question.type";
$query = $this->db->query($sql, array($type));
$result = $query->result_array();
$message .= "</br>****<strong><u>Test Details::Scenerio Section</u></strong>**** </br>";
foreach ($result as $row) {
$message .= "<strong>" . $row['texts'] . "</strong></br><strong><u>Ans: </u></strong>" . $row['answer'] . "</br>";
}
// load the email library that provided by CI
//$this->load->library('email', $config);
$this->load->library('email');
// this will bind your attributes to email library
//$this->email->set_newline("\r\n");
$this->email->from($from, 'Space Coast IC');
$this->email->to($to);
$this->email->subject($subject);
$this->email->message($message);
$this->email->set_mailtype("html");
// send your email. if it produce an error it will print 'Fail to send your message!' for you
if ($this->email->send()) {
$sql = "update scic_result set\n notification=1\n where user_id={$id}";
return $this->db->query($sql);
} else {
echo "Fail to send your message!";
}
}
Current Page: <?php
echo $page;
?>
</div>
<ul>
<?php
$search = "";
$query = "SELECT rsn FROM rsAcc";
if (isset($_GET['search'])) {
if (preg_match('([A-Za-z0-9\\-\\_]+)', $_GET['search'])) {
$query = $query . " WHERE rsn LIKE '%" . $sql->escape($_GET['search']) . "%'";
$search = "&search=" . $_GET['search'];
}
}
$query = $query . " ORDER BY " . $sortType . " " . $sortDir;
$count = ceil($sql->count($query) / $perPage);
if ($page > 1) {
echo "<li><a href=\"?page=" . ($page - 1) . "&sortType={$sortType}&sortDir={$realDir}{$search}\">◀</a></li>";
} else {
echo "<li>◁</li>";
}
for ($i = 1; $i < $count + 1; $i++) {
echo "<li><a href=\"?page={$i}&sortType={$sortType}&sortDir={$realDir}{$search}\">{$i}</a></li>";
}
if ($page < $count) {
echo "<li><a href=\"?page=" . ($page + 1) . "&sortType={$sortType}&sortDir={$realDir}{$search}\">▶</a></li>";
} else {
echo "<li>▷</li>";
}
?>
</ul>
function get_question_grid()
{
$sortname = common::getVar('sidx', 'id');
$sortorder = common::getVar('sord', 'desc');
$sort = " ORDER BY {$sortname} {$sortorder}";
$searchField = $_REQUEST['searchField'];
//common::getVar('searchField');
//$searchValue = common::getVar('searchValue');
$con = 1;
if ($searchField != '0' && $searchField != '') {
$searchField = $searchField - 1;
$con .= " and type = {$searchField} ";
}
$sql = "select * from scic_question where " . $con . $sort;
$page = common::getVar('page', 1);
$limit = common::getVar('rows');
$i = 0;
$count = sql::count('scic_question', '1');
if ($count > 0) {
$total_pages = ceil($count / $limit);
} else {
$total_pages = 5;
}
if ($page > $total_pages) {
$page = $total_pages;
}
if ($limit < 0) {
$limit = 0;
}
$start = $limit * $page - $limit;
if ($start < 0) {
$start = 0;
}
$sql_query = $this->db->query($sql . " limit {$start}, {$limit}");
$rows = $sql_query->result_array();
$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count;
foreach ($rows as $row) {
if ($row['type'] == 0) {
$label = "General";
} else {
if ($row['type'] == 1) {
$label = "First Part";
} else {
if ($row['type'] == 2) {
$label = "Second part";
} else {
if ($row['type'] == 3) {
$label = "Third part";
} else {
$label = "None";
}
}
}
}
$responce->rows[$i]['id'] = $row['id'];
$responce->rows[$i]['cell'] = array($row['texts'], $label, $row['status']);
$i++;
}
header("Expires: Sat, 17 Jul 2010 05:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . "GMT");
header("Cache-Control: no-cache, must-revalidate");
header("Pragma: no-cache");
header("Author:Mohaimen khan");
header("Email: joyes@sec.ac.bd");
header("Content-type: text/x-json");
echo json_encode($responce);
return '';
}
