$limit = "LIMIT {$start}, {$rp}"; $where = ""; if ($query) { $where = " WHERE {$qtype} LIKE '%{$query}%' "; } // for filter firstname by letter if (isset($_POST['letter_pressed']) && $_POST['letter_pressed'] != '') { if ($_POST['letter_pressed'] != 'All') { if (trim($where) == '') { $where = " WHERE firstname LIKE '" . $_POST['letter_pressed'] . "%' "; } $where .= " AND firstname LIKE '" . $_POST['letter_pressed'] . "%' "; } } $sql = "SELECT * FROM phonebook {$where} {$sort} {$limit}"; $data = runSQL($sql); $total = countRec("id", "phonebook {$where}"); header("Content-type: application/json"); $jsonData = array('page' => $page, 'total' => $total, 'rows' => array()); $index = 1; foreach ($data as $row) { //If cell's elements have named keys, they must match column names //Only cell's with named keys and matching columns are order independent. $ext = !isset($row['extension']) || $row['extension'] == '' ? '' : '<a href="javascript:void(0)" onclick="make_call(\'' . $row['extension'] . '\')"' . ">\n <img src='modules/agent_console/images/call.png' title='Gọi số " . $row['extension'] . "'/></a> " . $row['extension']; $mob = !isset($row['mobile']) || $row['mobile'] == '' ? '' : '<a href="javascript:void(0)" onclick="make_call(\'' . $row['mobile'] . '\')"' . ">\n <img src='modules/agent_console/images/call.png' title='Gọi số " . $row['mobile'] . "'/></a> " . $row['mobile']; $com_mob = !isset($row['company_mobile']) || $row['company_mobile'] == '' ? '' : '<a href="javascript:void(0)" onclick="make_call(\'' . $row['company_mobile'] . '\')"' . ">\n <img src='modules/agent_console/images/call.png' title='Gọi số " . $row['mobile'] . "'/></a> " . $row['company_mobile']; $entry = array('id' => $row['id'], 'cell' => array('stt' => $index, 'firstname' => $row['firstname'], 'lastname' => $row['lastname'], 'company_mobile' => $com_mob, 'mobile' => $mob, 'extension' => $ext, 'email' => '<a title="Gửi mail đến hộp mail này" href="mailto:' . $row['email'] . '?Subject=[CallCenter]" target="_top">' . $row['email'] . '</a>', 'note' => $row['note'], 'department' => $row['department'])); $index++; $jsonData['rows'][] = $entry; } echo $json->encode($jsonData);
} if (!$sortorder) { $sortorder = 'desc'; } $sort = "ORDER BY {$sortname} {$sortorder}"; if (!$page) { $page = 1; } if (!$rp) { $rp = 10; } $start = ($page - 1) * $rp; $limit = "LIMIT {$start}, {$rp}"; $sql = "SELECT iso,name,printable_name,iso3,numcode FROM country {$sort} {$limit}"; $result = runSQL($sql); $total = countRec('iso', 'country'); header("Expires: Mon, 26 Jul 1997 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("Content-type: text/xml"); $xml = "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n"; $xml .= "<rows>"; $xml .= "<page>{$page}</page>"; $xml .= "<total>{$total}</total>"; while ($row = mysql_fetch_array($result)) { $xml .= "<row id='" . $row['iso'] . "'>"; $xml .= "<cell><![CDATA[" . $row['iso'] . "]]></cell>"; $xml .= "<cell><![CDATA[" . utf8_encode($row['name']) . "]]></cell>"; //$xml .= "<cell><![CDATA[".print_r($_POST,true)."]]></cell>"; $xml .= "<cell><![CDATA[" . utf8_encode($row['printable_name']) . "]]></cell>";
} if (!$rp) { $rp = 10; } $start = ($page - 1) * $rp; $limit = "LIMIT {$start}, {$rp}"; $query = $_POST['query']; $qtype = $_POST['qtype']; $where = ""; if ($query) { $where = " WHERE {$qtype} LIKE '%{$query}%' "; } global $database; $sql = "SELECT top_id,top_title,sub_id FROM topics {$where} {$sort} {$limit}"; $result = $database->query($sql); $total = countRec("top_id", "topics {$where}"); header("Expires: Mon, 26 Jul 1997 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("Content-type: text/x-json"); $json = ""; $json .= "{\n"; $json .= "page: {$page},\n"; $json .= "total: {$total},\n"; $json .= "rows: ["; $rc = false; while ($row = mysql_fetch_array($result)) { if ($rc) { $json .= ","; }
if ($query) { $where = " WHERE {$qtype} LIKE '%{$query}%' "; } } if (isset($_POST['letter_pressed']) && $_POST['letter_pressed'] != '') { if ($_POST['letter_pressed'] != 'All') { if (trim($where) == '') { $where = " WHERE SUBSTRING_INDEX(customer_name,' ',-1) LIKE '" . $_POST['letter_pressed'] . "%' "; } $where .= " AND SUBSTRING_INDEX(customer_name,' ',-1) LIKE '" . $_POST['letter_pressed'] . "%' "; } } $sql = "SELECT a.id, a.customer_name, a.customer_phone, a.purchase_date, b.name as agent, a.status,\n a.pay_amount, c.name as delivery_man, a.delivery_date, a.collection_date, a.isActive\n FROM ticket_delivery a LEFT JOIN agent b ON a.agent_id = b.id\n LEFT JOIN ticket_delivery_user c on a.user_id = c.id\n {$where} {$sort} {$limit}"; $data = runSQL($sql); //var_dump($sql); $total = countRec("a.id", $where); $jsonData = array('page' => $page, 'total' => $total, 'rows' => array()); foreach ($data as $row) { //If cell's elements have named keys, they must match column names //Only cell's with named keys and matching columns are order independent. $ticket_id = $row['id']; $codes = runSQL("SELECT ticket_code FROM ticket_delivery_code WHERE ticket_id='{$ticket_id}'"); $code_list = ''; foreach ($codes as $code) { $code_list .= $code['ticket_code'] . '<br/>'; } $phone = '<a href="javascript:void(0)" onclick="make_call(\'' . $row['customer_phone'] . '\')"' . ">\n <img border=0 src='modules/agent_console/images/call.png' \n\t\ttitle='Gọi số " . $row['customer_phone'] . "'/></a> " . $row['customer_phone']; // status "Da Huy" if ($row['isActive'] == '0') { $row['status'] = 'Đã hủy'; }
if ($page == 1) { $start = $page; $end = $rp; } else { $start = ($page - 1) * $rp + 1; $end = $page * $rp; } $limit = "ROWS {$start} to {$end} "; $where = ""; if ($query) { $where = " WHERE {$qtype} CONTAINING '" . $query . "' "; } $sql = "SELECT * FROM SEL_USUARIOS_EMPRESA_GRID(" . $params . "," . $params2 . ") {$where} {$sort} {$limit}"; //echo $sql."</br>"; $result = runSQL($sql); $total = countRec('IDUSUARIO', 'SEL_USUARIOS_EMPRESA_GRID(' . $params . ',' . $params2 . ')'); $objJson = new Json(); $valorArray = $objJson->objectToArray($result); $total = $objJson->objectToArray($total); $total = $total[0]['COUNT']; //header("Content-type: application/json"); $jsonData = array('page' => $page, 'total' => $total, 'rows' => array()); foreach ($valorArray as $row) { if ($row['ATIVO'] == 1) { $row['ATIVO'] = 'Sim'; } else { $row['ATIVO'] = 'Não'; } $entry = array('counter' => $row['IDUSUARIO'], 'cell' => array('IDUSUARIO' => $row['IDUSUARIO'], 'NOME' => strtoupper($row['NOME']), 'CODIGO' => $row['CODIGO'], 'IDIDIOMA' => $row['IDIDIOMA'], 'IDIOMA' => $row['IDIOMA'], 'LOGIN' => $row['LOGIN'], 'ATIVO' => $row['ATIVO'], 'TELEFONE' => $row['TELEFONE'], 'IDPERFIL' => $row['IDPERFIL'], 'PERFIL' => $row['PERFIL'], 'OBSERVACAO' => $row['OBSERVACAO'])); $jsonData['rows'][] = $entry; }
if (!$sortname) { $sortname = 'id'; } if (!$sortorder) { $sortorder = 'desc'; } $sort = "ORDER BY {$sortname} {$sortorder}"; if (!$page) { $page = 1; } if (!$rp) { $rp = 10; } $start = ($page - 1) * $rp; $limit = "LIMIT {$start}, {$rp}"; $total = countRec(); for ($i = 1; $i <= get_option('cforms_formcount'); $i++) { $n = $i == 1 ? '' : $i; $fnames[$i] = stripslashes(get_option('cforms' . $n . '_fname')); } $sql = "SELECT * FROM {$wpdb->cformssubmissions} {$where} {$sort} {$limit}"; $result = $wpdb->get_results($sql); header("Expires: Mon, 26 Jul 1997 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("Content-type: text/xml"); $xml = "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n"; $xml .= "<rows>"; $xml .= "<page>{$page}</page>"; $xml .= "<total>{$total}</total>";
$page = 1; } if (!$rp) { $rp = 10; } $start = ($page - 1) * $rp; $limit = "LIMIT {$start}, {$rp}"; $query = $_POST['query']; $qtype = $_POST['qtype']; $where = ""; if ($query) { $where = " WHERE {$qtype} LIKE '%{$query}%' "; } $sql = "SELECT q_id,q_text,q_op1,q_op2,q_op3,q_op4,q_ans,top_id FROM questions {$where} {$sort} {$limit}"; $result = $database->query($sql); $total = countRec("q_id", "questions {$where}"); header("Expires: Mon, 26 Jul 1997 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("Content-type: text/x-json"); $json = ""; $json .= "{\n"; $json .= "page: {$page},\n"; $json .= "total: {$total},\n"; $json .= "rows: ["; $rc = false; while ($row = mysql_fetch_array($result)) { if ($rc) { $json .= ","; }
<?php header("Content-type: text/html; charset=ISO-8859-1"); require_once 'include/inc_db.php'; require_once 'control_login.php'; $sql = 'select * from quizzes where id = ' . $_POST['id']; $rs_result = execute($sql); $rs = mysql_fetch_array($rs_result); $question_num = countRec('id', 'questions', 'where id_quiz =' . $_POST['id']); ?> <div class="obj_title"><img src="ico.png" alt="" style="margin-right:5px;vertical-align:middle" />EDIT QUIZ</div> <div class="buttons_barr"> <span class="back_list"><img src="<?php echo path_img; ?> /back.png" alt=""/>Return To List</span> <span class="add_new_item"><img src="<?php echo path_img; ?> /add.png" alt=""/>New Quiz</span> </div> <!-- end of buttons bar --> <script type="text/javascript"> jQuery(function($){ <?php if ($question_num == 1) { ?> $('.delete_input:first').css('display','none'); <?php } else { ?>
$page = 1; } if (!$rp) { $rp = 10; } $start = ($page - 1) * $rp; $limit = "LIMIT {$start}, {$rp}"; $query = $_POST['query']; $qtype = $_POST['qtype']; $where = ""; if ($query) { $where = " WHERE {$qtype} LIKE '%{$query}%' "; } $sql = "SELECT iso,name,printable_name,iso3,numcode FROM country {$where} {$sort} {$limit}"; $result = runSQL($sql); $total = countRec("iso", "country {$where}"); header("Expires: Mon, 26 Jul 1997 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("Content-type: text/x-json"); $json = ""; $json .= "{\n"; $json .= "page: {$page},\n"; $json .= "total: {$total},\n"; $json .= "rows: ["; $rc = false; while ($row = mysql_fetch_array($result)) { if ($rc) { $json .= ","; }
} if (!$rp) { $rp = 10; } $start = ($page - 1) * $rp; $limit = "LIMIT {$start}, {$rp}"; $query = $_POST['query']; $qtype = $_POST['qtype']; $where = ""; if ($query) { $where = " WHERE {$qtype} LIKE '%{$query}%' "; } global $database; $sql = "SELECT username,userlevel,email,timestamp,branch_id FROM users {$where} {$sort} {$limit}"; $result = $database->query($sql); $total = countRec("username", "users {$where}"); header("Expires: Mon, 26 Jul 1997 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("Content-type: text/x-json"); $json = ""; $json .= "{\n"; $json .= "page: {$page},\n"; $json .= "total: {$total},\n"; $json .= "rows: ["; $rc = false; while ($row = mysql_fetch_array($result)) { if ($rc) { $json .= ","; }
$page = 1; } if (!$rp) { $rp = 10; } $start = ($page - 1) * $rp; $limit = "LIMIT {$start}, {$rp}"; $query = $_POST['query']; $qtype = $_POST['qtype']; $where = ""; if ($query) { $where = " WHERE {$qtype} LIKE '%{$query}%' "; } $sql = "SELECT sub_id,sub_title,bran_id FROM subjects {$where} {$sort} {$limit}"; $result = $database->query($sql); $total = countRec("sub_id", "subjects {$where}"); header("Expires: Mon, 26 Jul 1997 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("Content-type: text/x-json"); $json = ""; $json .= "{\n"; $json .= "page: {$page},\n"; $json .= "total: {$total},\n"; $json .= "rows: ["; $rc = false; while ($row = mysql_fetch_array($result)) { if ($rc) { $json .= ","; }
} if (!$sortorder) { $sortorder = 'desc'; } $sort = "ORDER BY {$sortname} {$sortorder}"; if (!$page) { $page = 1; } if (!$rp) { $rp = 10; } $start = ($page - 1) * $rp; $limit = "LIMIT {$start}, {$rp}"; $sql = "SELECT id,qq_group,name,qq,sex,tel FROM cssrain {$sort} {$limit}"; $result = runSQL($sql); $total = countRec('id', 'cssrain'); header("Expires: Mon, 26 Jul 1997 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("Content-type: text/x-json"); $json = ""; $json .= "{\n"; $json .= "page: {$page},\n"; $json .= "total: {$total},\n"; $json .= "rows: ["; $rc = false; while ($row = mysql_fetch_array($result)) { if ($rc) { $json .= ","; }
$pag = 1; } $limit_end = $counter; $limit_start = ($pag - 1) * $limit_end; if ($sqlsearch_or != '') { $sqlsearch = $sqlsearch . '(' . $sqlsearch_or; } if ($sqlsearch != '') { if ($sqlsearch_or != '') { $sqlsearch = ' Where ' . substr($sqlsearch, 0, strlen($sqlsearch) - 4) . ')' . $additional_where; } else { $sqlsearch = ' Where ' . substr($sqlsearch, 0, strlen($sqlsearch) - 5) . $additional_where; } $quanti = countRec('id', $table, $sqlsearch); } else { $quanti = countRec('id', $table, $additional_where_nosearch); } if ($sqlsearch != '') { $sql = ' select * from ' . $table . ' ' . $sqlsearch . ' order by ' . $order_record . ' ' . $order_verse . ' LIMIT ' . $limit_start . ', ' . $limit_end; } else { $sql = 'select * from ' . $table . $additional_where_nosearch . ' order by ' . $order_record . ' ' . $order_verse . ' LIMIT ' . $limit_start . ', ' . $limit_end; } $rs_result = execute($sql); $result = "{"; $result .= "\"page\":{$pag},"; $result .= "\"total\":{$quanti}"; if ($quanti > 0) { $result .= ",\"rows\":["; while ($rs = mysql_fetch_array($rs_result)) { $img_del = '<img id="' . $rs['id'] . '" src="' . path_img . '/del.png" style="cursor:pointer;margin-right:5px" alt="" class="delete" title="Delete" />'; $img_get_code = '<img id="' . $rs['id'] . '" rel="' . path_stored_quizzes . '/' . $rs['id'] . '/' . $rs['code'] . '.php" src="' . path_img . '/code.png" style="cursor:pointer;margin-right:5px" alt="" class="getcode" title="Get ShortCode to include this quiz in your pages" />';
} if (!$rp) { $rp = 10; } $start = ($page - 1) * $rp; $limit = "LIMIT {$start}, {$rp}"; $query = $_REQUEST['q']; $qtype = $_REQUEST['qtype']; $where = ""; if ($query) { $where = " WHERE {$qtype} LIKE '%{$query}%' "; } global $database; $sql = "SELECT bran_id,bran_name FROM branch {$where} {$sort} {$limit}"; $result = $database->query($sql); $total = countRec("bran_id", "branch {$where}"); header("Expires: Mon, 26 Jul 1997 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("Content-type: text/x-json"); $json = ""; $json .= "{\n"; $json .= "page: {$page},\n"; $json .= "total: {$total},\n"; $json .= "rows: ["; $rc = false; while ($row = mysql_fetch_array($result)) { if ($rc) { $json .= ","; }