function get_products($page, $per_page, $short = false)
{
$start = abs($page * $per_page);
$fields = $short ? 'product.id' : '*';
if (isset($_GET['sort'])) {
$sort_query = $_GET['sort'];
} elseif (!empty($_POST['sort'])) {
$sort_query = $_POST['sort'];
} else {
$sort_query = 'id_asc';
}
$cache_key = build_cache_key($page, $sort_query);
$result = get_cache($cache_key);
if (!$result) {
$sort_data = get_sort($sort_query);
$sort = $sort_data['sort'];
$sort_field = $sort_data['sort_field'];
if ($sort_field == 'id') {
$q = 'select ' . $fields . ' from product JOIN (SELECT ' . $sort_field . ' FROM product ' . $sort . ' LIMIT ' . $start . ',' . $per_page . ') as b ON b.id = product.id';
} elseif ($sort_field == 'price') {
$q = 'select ' . $fields . ' from product JOIN (SELECT id, price FROM product ' . $sort . ' LIMIT ' . $start . ',' . $per_page . ') as b ON b.id = product.id';
}
$res = query($q);
} else {
$q = 'select ' . $fields . ' from product where id in(' . $result . ');';
$res = query($q);
}
return $res;
}
echo get_status($deal["is_success"]);
?>
</td><td><?php
echo $deal["focus_count"];
?>
</td><td><?php
echo $deal["support_count"];
?>
</td><td><?php
echo to_date($deal["create_time"]);
?>
</td><td><?php
echo get_to_date($deal["end_time"]);
?>
</td><td><?php
echo get_sort($deal["sort"], $deal['id']);
?>
</td><td><?php
echo get_toogle_status($deal["is_special"], $deal['id'], is_special);
?>
</td><td><?php
echo get_toogle_status($deal["is_recommend"], $deal['id'], is_recommend);
?>
</td><td><?php
echo get_toogle_status($deal["is_classic"], $deal['id'], is_classic);
?>
</td><td><?php
echo get_toogle_status($deal["is_hot"], $deal['id'], is_hot);
?>
</td><td class="op_action"><div class="viewOpBox_demo"> <?php
echo get_edit($deal["id"], $deal);
} else {
?>
<?php
}
?>
</td><td><?php
echo $dealcity["id"];
?>
</td><td><?php
echo $dealcity["name"];
?>
</td><td><?php
echo get_is_default($dealcity["is_default"], $dealcity['id']);
?>
</td><td><?php
echo get_sort($dealcity["sort"], $dealcity['id']);
?>
</td><td><?php
echo get_is_effect($dealcity["is_effect"], $dealcity['id']);
?>
</td><td><a href="javascript:edit('<?php
echo $dealcity["id"];
?>
')"><?php
echo L("EDIT");
?>
</a> <a href="javascript: del('<?php
echo $dealcity["id"];
?>
')"><?php
echo L("DEL");
echo $article["title"];
?>
</a></td><td> <?php
echo get_cate_name($article["cate_id"]);
?>
</td><td> <?php
echo get_is_effect($article["is_effect"], $article['id']);
?>
</td><td> <?php
echo to_date($article["create_time"]);
?>
</td><td> <?php
echo to_date($article["update_time"]);
?>
</td><td> <?php
echo get_sort($article["sort"], $article['id']);
?>
</td><td> <?php
echo $article["click_count"];
?>
</td><td><a href="javascript:edit('<?php
echo $article["id"];
?>
')"><?php
echo L("EDIT");
?>
</a> <a href="javascript: del('<?php
echo $article["id"];
?>
')"><?php
echo L("DEL");
} else {
?>
<?php
}
?>
</td><td><?php
echo $cate["id"];
?>
</td><td><a href="javascript:edit('<?php
echo addslashes($cate["id"]);
?>
')"><?php
echo $cate["title"];
?>
</a></td><td><?php
echo get_sort($cate["sort"], $cate['id']);
?>
</td><td><a href="javascript:edit('<?php
echo $cate["id"];
?>
')"><?php
echo L("EDIT");
?>
</a> <a href="javascript: foreverdel('<?php
echo $cate["id"];
?>
')"><?php
echo L("DEL");
?>
</a> </td></tr><?php
}
text_input("{$_Source_date}:", 20, 'source_date', $source_date);
form_submit();
form_end();
$row = fetch_row("SELECT ecc({$source}), rcc({$source}), ssc({$source})");
printf("<p>{$_There_are} %s %s, %s %s {$_and} %s %s {$_associated_with_this_source}.</p>", $row[0], $row[0] == 1 ? $_event : $_events, $row[1], $row[1] == 1 ? $_relation : $_relations, $row[2], $row[2] == 1 ? $_subsource : $_subsources);
echo "</body>\n</html>\n";
} else {
$person = $_POST['person'];
$source = $_POST['source'];
$text = $_POST['text'];
$source_date = $_POST['source_date'] ? $_POST['source_date'] : fetch_val("SELECT true_date_extract('{$text}')");
$psource = $_POST['psource'] ? $_POST['psource'] : 0;
$sort = $_POST['sort'] ? $_POST['sort'] : 1;
$part_type = $_POST['part_type'];
$ch_part_type = isset($_POST['ch_part_type']) ? $_POST['ch_part_type'] : 0;
$sort = get_sort($psource, $text, $sort);
$text = note_to_db($text);
$ret = $_POST['ret'];
$template = isset($_POST['template']) ? $_POST['template'] : false;
if ($template) {
if (fetch_val("\n SELECT count(*)\n FROM templates\n WHERE source_fk = {$source}\n ")) {
pg_query("\n UPDATE templates\n SET template = '{$template}'\n WHERE source_fk = {$source}\n ");
} else {
pg_query("\n INSERT INTO templates (source_fk, template)\n VALUES ({$source}, '{$template}')\n ");
}
}
// this is a freak situation that arises when $psource = 0
// and a rather brute hack to remedy it.
if ($source == $psource) {
$psource = 0;
}
echo $brand["id"];
?>
</td><td> <?php
echo $brand["name"];
?>
</td><td> <?php
echo get_shop_cate_name($brand["shop_cate_id"]);
?>
</td><td> <?php
echo get_status($brand["brand_promote"]);
?>
</td><td> <?php
echo get_brand_time_status($brand["time_status"], $brand['id']);
?>
</td><td> <?php
echo get_sort($brand["sort"], $brand['id']);
?>
</td><td><a href="javascript:edit('<?php
echo $brand["id"];
?>
')"><?php
echo L("EDIT");
?>
</a> <a href="javascript: foreverdel('<?php
echo $brand["id"];
?>
')"><?php
echo L("DEL");
?>
</a> </td></tr><?php
}
case 6:
$tab = $array['nb_point_for'];
$option_1 = "SORT_DESC";
break;
default:
$tab = $array['point'];
$option_1 = "SORT_DESC";
}
return $tab;
}
}
if ($page['show_point'] == 1) {
# we have to sort the clubs id by points
if (!empty($global)) {
$tab_1 = get_sort($order_team, $global);
$tab_2 = get_sort($order_team_egality, $global);
array_multisort($tab_1, SORT_DESC, $tab_2, SORT_DESC, $global['id'], SORT_ASC, $club_id);
/*$tab_1=get_sort($order_team,$global);
$tab_2=get_sort($order_team_egality,$global);
$tab_3=get_sort(6,$global);
array_multisort($tab_1, SORT_DESC, $tab_2, SORT_DESC, $tab_3, SORT_DESC, $global['id'], SORT_ASC, $club_id);
*/
}
} else {
# we sort the club list by name
if (!empty($global)) {
array_multisort($global['name'], SORT_ASC, $global['id'], SORT_ASC, $club_id);
}
}
# date sort by nb_match //////////// to be change by points !!
/*if(!empty($home)) {
function init_sort(&$table){
if(!$GLOBALS['sort']=get_sort()) $GLOBALS['sort']=$table['sort_default'];
if(!$GLOBALS['sort_direction']=get_sort_direction()) $GLOBALS['sort_direction']=$table['sort_direction_default'];
$table['sort']=$sort;
$table['sort_direction']=$sort_direction;
}
