/** * ShopEx licence * * @copyright Copyright (c) 2005-2010 ShopEx Technologies Inc. (http://www.shopex.cn) * @license http://ecos.shopex.com/license/gpl GPL License */ function widget_goods(&$setting, &$render) { $limit = intval($setting['limit']) > 0 ? intval($setting['limit']) : 6; $goods =& app::get('b2c')->model('goods'); $goods->defaultCols = 'bn,name,cat_id,price,store,marketable,brand_id,weight,d_order,uptime,type_id'; $goods->appendCols = 'goods_id,thumbnail_pic,brief,mktprice,image_default_id'; $config = app::get('b2c')->getConf('site.save_price'); $data['onSelect'] = $setting['onSelect'] ? $setting['onSelect'] : 0; $setting['max_length'] = $setting['max_length'] ? $setting['max_length'] : 35; $setting['view'] = app::get('b2c')->getConf('gallery.default_view'); $imageDefault = app::get('image')->getConf('image.set'); $search =& app::get('b2c')->model('search'); $setting['str'] = $search->encode($filter); $setting['restrict'] = $setting['restrict'] ? $setting['restrict'] : 'on'; $order = $setting['goods_orderby'] ? orderBy($setting['goods_orderby']) : null; if ($setting['columNum'] > 1) { for ($i = 0; $i < $setting['columNum']; $i++) { parse_str($setting['adjunct']['items'][$i], $filter[$i]); $filter[$i] = getFilter($filter[$i]); $result['link'][$i - 1] =& kernel::router()->gen_url(array('app' => 'b2c', 'ctl' => 'gallery', 'act' => $setting['view'], 'args' => array($str_cat_id, $search->encode($filter[$i]), $setting['goods_orderby'] ? $setting['goods_orderby'] : 0))); $result['goods'][] = $goods->getList(null, $filter[$i], 0, $limit, $order['sql']); $result['defaultImage'] = $imageDefault['S']['default_image']; unset($filter[$i]); } return $result; } else { parse_str($setting['adjunct']['items'][0], $filter); $filter = getFilter($filter); $result['link'] =& kernel::router()->gen_url(array('app' => 'b2c', 'ctl' => 'site_gallery', 'act' => $setting['view'], 'args' => array(implode(",", (array) $filter['cat_id']), $search->encode($filter), $setting['goods_orderby'] ? $setting['goods_orderby'] : 0))); $result['goods'] = $goods->getList('*', $filter, 0, $limit, $order['sql']); $result['defaultImage'] = $imageDefault['S']['default_image']; return $result; } }
function listUserCaches($userid) { global $db; // lists all approved caches belonging to user $sql = "SELECT cache_id, name, date_hidden FROM caches WHERE user_id=:1 AND status <> 4 AND type != 10 ORDER BY " . orderBy(@$_GET['orderId']) . " " . orderType(@$_GET['orderType']); $db->multiVariableQuery($sql, $userid); return $db->dbResultFetchAll(); }
function getAllStudents($orderby, $desc) { $query = "SELECT U.`User ID` ID, U.`First Name` FName, U.`Surname` SName FROM TUSERS U " . "JOIN TSTUDENTS S ON S.`User ID` = U.`User ID` "; $query .= orderBy([$orderby], [$desc]); try { $users = db_select_exception($query); } catch (Exception $ex) { $message = "There was an error loading the students"; returnToPageError($ex, $message); } $response = array("success" => TRUE, "users" => $users); echo json_encode($response); }
function getSetsForStaffMember($staffid, $orderby, $desc) { $query = "select G.`Group ID` ID, G.`Name` Name from TGROUPS G\n join TUSERGROUPS UG on G.`Group ID` = UG.`Group ID`"; $query .= filterBy(["UG.`User ID`", "G.`Type ID`", "UG.`Archived`"], [$staffid, 3, 0]); $query .= orderBy([$orderby], [$desc]); try { $sets = db_select_exception($query); } catch (Exception $ex) { errorLog("Error loading the worksheets: " . $ex->getMessage()); $response = array("success" => TRUE); echo json_encode($response); } $response = array("success" => TRUE, "sets" => $sets); echo json_encode($response); }
function getAllCompletedWorksheetsForGroup($groupid, $staffid, $orderby, $desc) { $query = "SELECT GW.`Group Worksheet ID` ID, WV.`WName` WName, DATE_FORMAT(GW.`Date Due`, '%d/%m/%Y') DueDate FROM TGROUPWORKSHEETS GW \n JOIN TWORKSHEETVERSION WV ON GW.`Version ID` = WV.`Version ID` "; $query .= filterBy(["GW.`Group ID`", "GW.`Primary Staff ID`", "WV.`Deleted`"], [$groupid, $staffid, "0"]); $query .= "AND (GW.`Deleted` IS NULL OR GW.`Deleted` = 0) "; $query .= orderBy([$orderby], [$desc]); try { $worksheets = db_select_exception($query); } catch (Exception $ex) { $message = "There was an error retrieving the worksheets"; returnToPageError($ex, $message); } $response = array("success" => TRUE, "worksheets" => $worksheets); echo json_encode($response); exit; }
<?php $array = array(array('Cat_ID' => 81751, 'Cat_Name' => 'Äá»i sống', 'Cat_ParentID' => 104, 'Description' => ""), array('Cat_ID' => 1424, 'Cat_Name' => 'Giải trÃ', 'Cat_ParentID' => 104, 'Description' => ""), array('Cat_ID' => 1451, 'Cat_Name' => 'Giáo dục', 'Cat_ParentID' => 104, 'Description' => ""), array('Cat_ID' => 80923, 'Cat_Name' => 'Kh - cn', 'Cat_ParentID' => 104, 'Description' => ""), array('Cat_ID' => 1426, 'Cat_Name' => 'Kh - cn', 'Cat_ParentID' => 104, 'Description' => ""), array('Cat_ID' => 1433, 'Cat_Name' => 'Kh - cn', 'Cat_ParentID' => 104, 'Description' => ""), array('Cat_ID' => 1442, 'Cat_Name' => 'Nhà đất', 'Cat_ParentID' => 104, 'Description' => ""), array('Cat_ID' => 80891, 'Cat_Name' => 'Ô tô - xe máy', 'Cat_ParentID' => 104, 'Description' => ""), array('Cat_ID' => -999, 'Cat_Name' => 'Topnews', 'Cat_ParentID' => 0, 'Description' => "")); function orderBy($data, $field) { $code = "return strnatcmp(\$a['{$field}'], \$b['{$field}']);"; usort($data, create_function('$a,$b', $code)); return $data; } $sorted_data = orderBy($array, 'Cat_ParentID'); echo "<pre>"; var_dump($sorted_data);
<tr class="whiteTxt font14 bgGray"> <td align="center" width="2%"><input type="checkbox" onclick="checkedAll()" name="checkall"> </td> <td align="center" width="5%">#</td> <!-- <td align="center" width="10%">Language</td>--> <td align="center" width="20%"><?php echo orderBy(base_url("index.php/managepagecontaint/index/") . $pageId, "pageid", "Page Name", $page, $per_page, $order, $orderby); ?> </td> <td align="center" width="20%"><?php echo orderBy(base_url("index.php/managepagecontaint/index/") . $pageId, "pageid", "Page URL", $page, $per_page, $order, $orderby); ?> </td> <td align="center" width="20%"><?php echo orderBy(base_url("index.php/managepagecontaint/index/") . $pageId, "pageTitle", "Page Title", $page, $per_page, $order, $orderby); ?> </td> <td align="center" width="15%">Status</td> <td align="center" width="15%">View</td> <td align="center" width="15%">Edit</td> <td align="center" width="15%">Delete</td> </tr> <?php echo $this->pagecontaint_model->allrecord(); ?> </tbody> </table></td> </tr> </tbody> </table>
function test() { $name = 'Name'; $gender = 'Gender'; $studentInfo = array($name, $gender); $studentTbl = 'students'; $classIdCol = 'classId'; $classIdVal = '1'; return select($studentInfo) . from($studentTbl) . where(equals($classIdCol, $classIdVal)) . orderBy($name); // should return: // SELECT Name, Gender FROM students WHERE classId = '1' ORDER BY Name }
$idMember = $_REQUEST['hl']; if ($idMember && $idMember != "") { // is cURL installed yet? if (!function_exists('curl_init')) { die('Sorry cURL is not installed!'); } $curl = curl_init(); curl_setopt($curl, CURLOPT_URL, "http://api.keen.io/3.0/projects/568b585459949a717d66f540/queries/sum?api_key=c575436e9735c547b11a59e1c24cbe0fc0061d0c863e8707003614286877773fe7e898ee658c00c8c192d71bea7d4267760a0a54b457b0c3ffd053885be3f0042b5cbf1d61d8d5b5c8e3f718e6dfa886681905701c47d3f8126af05ad60e7ee9df63a6108be0f625f83522ceef628d9c&event_collection=page_view&timeframe=this_7_days&target_property=second&group_by=article.id_article&timezone=Asia/Jakarta"); curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1); $json = curl_exec($curl); curl_close($curl); //echo curl_error($curl); //print $json; $jsonResult = json_decode($json, true); $articleResults = $jsonResult['result']; $articleResults = orderBy($articleResults, 'result', 'desc'); //exit(); /* $inQuery = implode(',', array_fill(0, count($articleResults), '?')); $stmt = $conn->prepare('SELECT a.*, b.nama_content, b.data_file from tbl_content_article a left join tbl_content b on a.id_content = b.id_content where id_article IN(' . $inQuery . ')'); foreach ($articleResults as $k => $value){ $stmt->bindValue(($k+1), $value['article.id_article']); } $stmt->execute(); $articles = $stmt->fetch(PDO::FETCH_ASSOC); var_dump($articles); */ $placeHoldersTrendingTopics = implode(', ', array_fill(0, count($articleResults), '?')); $stmtResultTrendingTopics = $conn->prepare('select a.id as article_id, a.content_id, b.vendor_id, a.name as article_title, a.description, a.image as img_article, a.data_file as content_file, a.start_page, a.end_page, b.name as content_name, b.volume, b.edition, c.name as vendor_name, b.data_file, (select status from tbl_comlike z where z.content_article_id = a.id AND z.member_id = ? AND z.type = "like" limit 1) as status_like from tbl_content_article a left join tbl_content b on a.content_id = b.id left join tbl_vendor c on b.vendor_id = c.id where a.id IN (' . $placeHoldersTrendingTopics . ') AND a.status = 1');
?> " class="с1"><?php echo $arElement["NAME"]; ?> </a></span><br /> <span class="с2"><?php echo $arElement["PREVIEW_TEXT"]; ?> </span> </td> </tr> <tr> <td align="center"></td> <td align="right"><nobr><span class="с4"> <? $data = orderBy($arElement["PRICES"], 'VALUE'); foreach($data as $code=>$arPrice):?> <?if($arPrice["CAN_ACCESS"]):?> <?php echo $arPrice["PRINT_VALUE"]; ?> <?break;?> <?endif;?> <?endforeach;?> </span><span class="с5">руб.</span><span class="с4"> <a href="<?php echo $arElement["BUY_URL"]; ?> "><img src="/images/get.jpg" width="53" height="18" /></a> </span></nobr></td> </tr> </table> </td>
if ($dir == "asc") { $code = "return strnatcmp(strtolower(\$a['{$field}']), strtolower(\$b['{$field}']));"; } else { $code = "return strnatcmp(strtolower(\$b['{$field}']), strtolower(\$a['{$field}']));"; } usort($data, create_function('$a,$b', $code)); } $direction = $_GET['direction'] ? $_GET['direction'] : 'asc'; $order = $_GET['order'] ? $_GET['order'] : 'cust_surname'; $layout['pagetitle'] = trans('Lista klientów'); $ppage = 25; $list = $LMSTV->CustomerList(); $all = ceil(count($list) / $ppage); $page = (int) $_GET['page']; if ($page == -1) { $ppage = count($list); } if ($page == 0) { $page = 1; } orderBy($list, $order, $direction); $list = Zend_Paginator::factory($list); $list->setItemCountPerPage($ppage); $list->setCurrentPageNumber($page); $SMARTY->assign('order', $order); $SMARTY->assign('direction', $direction); $SMARTY->assign('list', $list); $SMARTY->assign('page', $page); $SMARTY->assign('all', $all); $SMARTY->assignByRef('smsurl', $LMSTV->smsurl); $SMARTY->display('tvcustomers.html');
break; case 'alcohol-desc': if ($richtingSess == 'ASC') { $order = orderBy($db, 'bieren.alcohol', 'DESC'); $_SESSION['richting'] = 'DESC'; } elseif ($richtingSess == 'DESC') { $order = orderBy($db, 'bieren.alcohol', 'ASC'); $_SESSION['richting'] = 'ASC'; } break; default: if ($richtingSess == 'ASC') { $order = orderBy($db, 'bieren.biernr', 'DESC'); $_SESSION['richting'] = 'DESC'; } elseif ($richtingSess == 'DESC') { $order = orderBy($db, 'bieren.biernr', 'ASC'); $_SESSION['richting'] = 'ASC'; } break; } } } catch (PDOException $e) { $message['type'] = 'error'; $message['text'] = 'Er kon geen verbinding gemaakt worden met de database. Probeer opnieuw.'; } function orderBy($database, $kolom, $richting) { $selectQuery = 'SELECT bieren.biernr, bieren.naam, brouwers.brnaam, soorten.soort,
<td><a class="lknombreColumna" href="#" onClick="cambiarOrderBy('<?php echo orderBy($C_USUARIO, !isset($_POST["orderByHidden"]) ? $C_USUARIO : $_POST["orderByHidden"]); ?> '), document.getElementById('Buscar').click();">Usuario <img src="down.gif" width="9" height="9" alt="Ordenar" border="0" /></a></td> <td><a class="lknombreColumna" href="#" onClick="cambiarOrderBy('<?php echo orderBy($C_FECHA, !isset($_POST["orderByHidden"]) ? $C_FECHA : $_POST["orderByHidden"]); ?> '), document.getElementById('Buscar').click();">Fecha <img src="down.gif" width="9" height="9" alt="Ordenar" border="0" /></a></td> <td>URL</td> <td><a class="lknombreColumna" href="#" onClick="cambiarOrderBy('<?php echo orderBy($C_RELACION, !isset($_POST["orderByHidden"]) ? $C_RELACION : $_POST["orderByHidden"]); ?> '), document.getElementById('Buscar').click();">Relación <img src="down.gif" width="9" height="9" alt="Ordenar" border="0" /></a></td> <td>¿Válida?</td> <td><a class="lknombreColumna" href="#" onClick="cambiarOrderBy('<?php echo orderBy($C_COMPARACION, !isset($_POST["orderByHidden"]) ? $C_COMPARACION : $_POST["orderByHidden"]); ?> '), document.getElementById('Buscar').click();">Precio <img src="down.gif" width="9" height="9" alt="Ordenar" border="0" /></a></td> <td>Comparar</td> <td width="25px" align="center">Estado</td> </tr> <?php foreach ($resultLineas as $linea) { ?> <tr style="font-family: Arial, Helvetica, sans-serif; font-size:9px; color:#000000; background-color:#FFFFFF;"> <td class="txtcampos"><input type="checkbox" name="checkEliminar[]" id="checkEliminar[]" value="<?php echo $linea['dacoId']; ?> " /></td> <td class="txtcampos"><?php echo $linea['dacoBip'];