-Pilih-'; } $sql = 'SELECT * FROM '.$maintable.' WHERE parentid=\''.intval($parent).'\' ORDER BY priority ASC '; $res = mysql_query($sql); $num = mysql_num_rows($res); if($num) { while($row = mysql_fetch_assoc($res)) { $child = show_select_opt_parent($row['catid'], $selected, '---'.$level); $is_selected = $selected == $row['catid'] ? ' selected="selected" ' : ''; $is_disabled = $child != '' ? ' disabled="disabled" ' : ''; $ret .= ''; $ret .= $child; } } return $ret; } $content_valid = ''; $thestrtime = time(); $thetime = date('Y-m-d H:i:s', $thestrtime); if(isset($_GET['s']) ) { $s = trim($_GET['s']); $m = intval($_GET['m']); $c = intval($_GET['c']); if($s == '' && $c == 0 && $m == 0) { $err_msg = 'Masukkan kata yang ingin dicari.'; } if($m > 0) { $search_catid = ' AND item_list.`sale_method` =\''.$m.'\' '; } if($c > 0) { $search_catid = ' AND item_list.`catid` =\''.$c.'\' '; $category = cq_get_parent($c); $category = explode('-', $category ); @array_pop($category); $qs = ''; foreach($category as $k => $v) { $q = cq_check_quest_id($v); $qs .= $q['quest_select']; } $qs = explode('-', $qs ); @array_pop($qs); $search_opt = ''; foreach($qs as $k => $v) { if($_GET['select_q_id'][$v] != '') { $search_opt .= ' OR ( item_opt_select.select_q_id='.$v.' AND item_opt_select.select_a_id='.intval($_GET['select_q_id'][$v]).' ) '; } } if( $search_opt != '') { $search_opt = substr($search_opt, 3); $search_opt = ' ( '.$search_opt.' ) AND '; } } if($err_msg == '') { if($search_opt != '') { $sql = 'SELECT item_list.item_id FROM item_opt_select LEFT JOIN `item_list` ON item_list.item_id=item_opt_select.item_id WHERE '.$search_opt.' item_list.`item_name` LIKE \'%'.$s.'%\' AND item_list.`sale_end` > \''.$thetime.'\' '.$search_catid.' AND item_list.endstat != 1 AND item_list.item_suspend=0 GROUP BY item_list.item_id ORDER BY item_list.item_id DESC '; } else { $sql = 'SELECT item_id FROM `item_list` WHERE `item_name` LIKE \'%'.$s.'%\' AND `sale_end` > \''.$thetime.'\' '.$search_catid.' AND item_list.endstat != 1 AND item_list.item_suspend=0 ORDER BY item_id DESC '; } $res = mysql_query($sql); $num = @mysql_num_rows($res); if($num) { $page = isset($_GET['page']) && intval($_GET['page']) >= 1 ? intval($_GET['page']):1; $perpage = 15; $param = 's='.$s.'&m='.$m.'&c='.$c.''; $pagination = paging($perpage, $num, $page, $param); if($search_opt != '') { //$sql = 'SELECT * FROM `item_list` WHERE `item_name` LIKE \'%'.$s.'%\' AND `sale_end` > \''.$thetime.'\' '.$search_catid.' ORDER BY item_id DESC LIMIT '.$pagination['from'].', '.$perpage.' '; $sql = 'SELECT * FROM item_opt_select LEFT JOIN `item_list` ON item_list.item_id=item_opt_select.item_id WHERE '.$search_opt.' item_list.`item_name` LIKE \'%'.$s.'%\' AND item_list.`sale_end` > \''.$thetime.'\' '.$search_catid.' AND item_list.endstat != 1 AND item_list.item_suspend=0 GROUP BY item_list.item_id ORDER BY item_list.item_id DESC LIMIT '.$pagination['from'].', '.$perpage.' '; } else { $sql = 'SELECT item_list.* FROM `item_list` WHERE item_list.`item_name` LIKE \'%'.$s.'%\' AND item_list.`sale_end` > \''.$thetime.'\' '.$search_catid.' AND item_list.endstat != 1 AND item_list.item_suspend=0 ORDER BY item_id DESC LIMIT '.$pagination['from'].', '.$perpage.' '; } $res = mysql_query($sql); $num = @mysql_num_rows($res); if($num) { $content_valid .= ''; $content_valid .= ' '; $no = $pagination['from']+1; while($row = mysql_fetch_assoc($res)) { $image = $row['mainimagename'] != '' && is_file('./upload/thumb_'.$row['mainimagename']) ? ''.$row['mainimagename'].'' : ' '; $bgcolor = $bgcolor == 'style1' ? 'style2' : 'style1'; $sale_end = strtotime($row['sale_end']); $content_valid .= ' '; $no++; } $content_valid .= '
Keterangan Barang Sistem penawaran Waktu berakhir Detil
'.$row['item_name'].'
'.$image.'
'.format_uang($row['item_price']).'
'.($row['sale_method'] == 2 ? 'Jual' : 'Lelang').' '.date('d-m-Y H:i:s', $sale_end) .' '; $content_valid .= 'Lihat detil..
'; $content_valid .= '

'.$pagination['first'].$pagination['prev'].''.$pagination['page'].''.$pagination['next'].$pagination['last'].'

'; } } else { $content_valid .= '
 
Maaf tidak ada data yang cocok dengan pencarian Anda
Silakan coba kata kunci pencarian yang lain.


 
'; } } else { $content_valid .= '
'.$err_msg.'
[Kembali]

'; } } ?> Rajalelang.com - Portal Lelang Online dan Jual Beli Barang Terbesar di Indonesia - Online Auction and Online Shopping Portal
 
 
Form Pencarian  
 
 
Nama barang :
Sistem penawaran :
Kategori :
   
 
 
Hasil Pencarian