$vals['product_id'] = $pdb->GetOne("SELECT id FROM {$tb_prefix}products WHERE name='" . $_POST['product_name'] . "'"); } } $trend['x'] = PbController::convertTextToArray($_POST['trend_data']['x']); $trend['y'] = PbController::convertTextToArray($_POST['trend_data']['y']); $vals['trend_data'] = serialize($trend); $vals['area_id'] = $vals['area_id3']; if (!empty($vals['content'])) { $vals['content'] = stripcslashes($vals['content']); } if (!empty($id)) { $vals['modified'] = $time_stamp; $result = $marketquotes->save($vals, "update", $id); } else { $vals['created'] = $vals['modified'] = $time_stamp; $result = $marketquotes->save($vals); } if (!$result) { flash(); } else { flash("success"); } } $amount = $marketquotes->findCount(null, $conditions); $page->setPagenav($amount); $joins[] = "LEFT JOIN {$tb_prefix}markets m ON m.id=Quote.market_id"; $fields = "Quote.id,m.name AS marketname,Quote.title AS title,Quote.max_price AS maxprice,Quote.min_price AS minprice"; $result = $marketquotes->findAll($fields, $joins, $conditions, "Quote.id DESC", $page->firstcount, $page->displaypg); uaAssign(array("ByPages" => $page->pagenav)); setvar("Items", $result); template($tpl_file);
} $info = $pdb->GetRow("SELECT * FROM " . $tb_prefix . "quotes WHERE id=" . $id); $pdb->Execute("UPDATE " . $tb_prefix . "quotes SET hits=hits+1 WHERE id=" . $id); $info['pubdate'] = df($info['created']); $info['clicked'] = $info['hits']; setvar("item", $info); $tpl_file = "detail.default"; render($tpl_file, true); break; case "search": if (!empty($_GET['title'])) { $conditions[] = "title LIKE '%" . pb_addslashes($_GET['title']) . "%'"; } break; default: break; } } if (isset($_GET['catid'])) { $type_id = intval($_GET['catid']); $conditions[] = "Quote.type_id='" . $type_id . "'"; $viewhelper->setTitle("The industry " . $type_id); } $quote->setCondition($conditions); $amount = $quote->findCount(null, $conditions); $fields = "Quote.*,Quote.created AS pubdate,ROUND((Quote.min_price+Quote.max_price)/2,2) AS price"; $result = $quote->findAll($fields, $joins, $conditions, "Quote.id DESC", $pos, $limit); setvar("items", $result); uaAssign(array("QuoteSearchFrom" => date("Y-m-d", strtotime("last month")), "QuoteSearchTo" => date("Y-m-d"))); setvar("paging", array('total' => $amount)); render($tpl_file);