}
}
/*团购*/
if ($foruminfo['pcid'] || $pcid > 0) {
L::loadClass('postcate', 'forum', false);
$postCate = new postCate($pwpost);
$pcids = explode(",", $foruminfo['pcid']);
if ($foruminfo['pcid']) {
$N_allowpostcateopen = true;
} else {
$N_allowpostcateopen = false;
}
}
if ($modelid > 0) {
/*分类信息*/
$fielddb = $postTopic->getFieldData($modelid, 'one');
foreach ($fielddb as $key => $value) {
if ($value['threadshow'] == 1) {
$threadshowfield[$key] = $value;
}
}
$colspannum = count($threadshowfield) + 2;
$initSearchHtml = $postTopic->initSearchHtml($modelid);
} elseif ($pcid > 0) {
/*团购*/
$fielddb = $postCate->getFieldData($pcid, 'one');
foreach ($fielddb as $key => $value) {
if ($value['threadshow'] == 1) {
$threadshowfield[$key] = $value;
}
}
function getSearchvalue($field, $type, $alltidtype = false, $backtype = false)
{
/*获取搜索结果*/
global $db_perpage, $page, $modelid, $fid, $basename;
$field = unserialize(StrCode($field, 'DECODE'));
$sqladd = '';
$fid && ($sqladd .= " fid=" . S::sqlEscape($fid));
$fielddb = postTopic::getFieldData($modelid, $type);
foreach ($field as $key => $value) {
if ($value) {
if (in_array($fielddb[$key]['type'], array('number', 'radio', 'select'))) {
$sqladd .= $sqladd ? " AND " . $fielddb[$key]['fieldname'] . "=" . S::sqlEscape($value) : $fielddb[$key]['fieldname'] . "=" . S::sqlEscape($value);
} elseif ($fielddb[$key]['type'] == 'checkbox') {
$checkboxs = '';
foreach ($value as $cv) {
$checkboxs .= $checkboxs ? ',' . $cv : $cv;
}
$value = '%,' . $checkboxs . ',%';
$sqladd .= $sqladd ? " AND " . $fielddb[$key]['fieldname'] . " LIKE(" . S::sqlEscape($value) . ")" : $fielddb[$key]['fieldname'] . " LIKE(" . S::sqlEscape($value) . ")";
} elseif ($fielddb[$key]['type'] == 'calendar' && ($value['start'] || $value['end'])) {
$value['start'] && ($value['start'] = PwStrtoTime($value['start']));
$value['end'] && ($value['end'] = PwStrtoTime($value['end']));
if ($value['start'] > $value['end'] && $value['start'] && $value['end']) {
Showmsg('calendar_error');
}
$sqladd .= $sqladd ? " AND " . $fielddb[$key]['fieldname'] . ">=" . S::sqlEscape($value['start']) . " AND " . $fielddb[$key]['fieldname'] . "<=" . S::sqlEscape($value['end']) : $fielddb[$key]['fieldname'] . ">=" . S::sqlEscape($value['start']) . " AND " . $fielddb[$key]['fieldname'] . "<=" . S::sqlEscape($value['end']);
} elseif (in_array($fielddb[$key]['type'], array('text', 'url', 'email', 'textarea'))) {
$value = '%' . $value . '%';
$sqladd .= $sqladd ? " AND " . $fielddb[$key]['fieldname'] . " LIKE(" . S::sqlEscape($value) . ")" : $fielddb[$key]['fieldname'] . " LIKE(" . S::sqlEscape($value) . ")";
} elseif ($fielddb[$key]['type'] == 'range' && $value['min'] && $value['max']) {
$sqladd .= $sqladd ? " AND " . $fielddb[$key]['fieldname'] . ">=" . S::sqlEscape($value['min']) . " AND " . $fielddb[$key]['fieldname'] . "<=" . S::sqlEscape($value['max']) : $fielddb[$key]['fieldname'] . ">=" . S::sqlEscape($value['min']) . " AND " . $fielddb[$key]['fieldname'] . "<=" . S::sqlEscape($value['max']);
} else {
$sqladd .= '';
}
}
}
if ($sqladd) {
!$page && ($page = 1);
$start = ($page - 1) * $db_perpage;
$limit = S::sqlLimit($start, $db_perpage);
$tablename = GetTopcitable($modelid);
$sqladd .= $sqladd ? " AND ifrecycle=0" : " ifrecycle=0";
$count = $this->db->get_value("SELECT COUNT(*) as count FROM {$tablename} WHERE {$sqladd}");
$query = $this->db->query("SELECT tid FROM {$tablename} WHERE {$sqladd} {$limit}");
while ($rt = $this->db->fetch_array($query)) {
$tiddb[] = $rt['tid'];
}
if ($alltidtype) {
$query = $this->db->query("SELECT tid FROM {$tablename} WHERE {$sqladd}");
while ($rt = $this->db->fetch_array($query)) {
$alltiddb[] = $rt['tid'];
}
}
!$count && ($count = -1);
} else {
if ($backtype) {
adminmsg('topic_search_none', "{$basename}&action=topic&modelid={$modelid}");
}
Showmsg('topic_search_none');
}
return array($count, $tiddb, $alltiddb);
}
