Example #1
0
/**
 * 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;
    }
}
Example #2
0
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();
}
Example #3
0
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);
}
Example #4
0
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);
}
Example #5
0
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;
}
Example #6
0
<?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);
Example #7
0
                                <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>
Example #8
0
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
}
Example #9
0
 $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');
Example #10
0
?>
" 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">&nbsp;<a href="<?php 
echo $arElement["BUY_URL"];
?>
"><img src="/images/get.jpg" width="53" height="18" /></a> </span></nobr></td>
				  </tr>
				</table>
			</td>
Example #11
0
    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&oacute;n <img src="down.gif" width="9" height="9" alt="Ordenar" border="0" /></a></td>
    <td>¿V&aacute;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'];