private function slugify($id)
{
$table = "investment_orgs";
$sql = "select * from `" . $table . "` where `id`='" . mysql_real_escape_string($id) . "'";
$q = $this->db->query($sql);
$list = $q->result_array();
$t = count($list);
for ($i = 0; $i < $t; $i++) {
$row = $list[$i];
$n = 1;
do {
$slug = seoIze($row['name']);
if ($n > 1) {
$slug = $slug . $n;
}
$sql = "select `id` from `" . $table . "` where `slug`='" . $slug . "' and `id`<>'" . $row['id'] . "'";
$q = $this->db->query($sql);
$rowtemp = $q->result_array();
$n++;
} while ($rowtemp[0]['id']);
$sql = "update `" . $table . "` set `slug`='" . $slug . "' where `id`='" . $row['id'] . "'";
$q = $this->db->query($sql);
}
}
</tr>
<?php
}
if (count($company['categories'])) {
?>
<tr>
<td class="label">
Categories
</td>
<td class="value small">
<?php
$ct = count($company['categories']);
$count = 0;
foreach ($company['categories'] as $value) {
$count++;
echo "<a href='" . site_url() . "category/" . seoIze($value['category']) . "'>" . $value['category'] . "</a> ";
if ($count >= 3) {
if ($count < $ct) {
?>
<a href="<?php
echo site_url();
?>
company/<?php
echo $company['slug'];
?>
">...<?php
}
break;
}
}
?>
public function all($q = "", $id = "")
{
$search = urldecode(trim($_GET['q']));
if (!$search) {
$search = urldecode(trim($q));
}
//get the categories
$sql = "select * from `categories` where 1";
$q = $this->db->query($sql);
$zcategories = $q->result_array();
$categories = array();
foreach ($zcategories as $value) {
$categories[seoIze(strtolower($value['category']))] = $value['id'];
}
//print_r($categories);
$searchx = $search;
$search = strtolower($search);
$search2 = explode(":", $search);
if ($search2[1]) {
$exact = trim($search2[0]);
$search2 = html_entity_decode(trim($search2[1]));
if ($exact != "country" && $exact != "category") {
$exact = "";
}
if ($exact == "category") {
$search2 = $categories[seoIze(strtolower($search2))];
}
}
$gfilter = trim($_GET['filter']);
$start = $_GET['start'];
$start += 0;
$limit = 3000;
$c_limit = 0;
//company limit
$p_limit = 0;
//person limit
$i_limit = 0;
//investment org limit
if ($gfilter == "companies") {
$c_limit = $limit;
//company limit
$c_start = $start / $limit * $c_limit;
} else {
if ($gfilter == "people") {
$p_limit = $limit;
//person limit
$p_start = $start / $limit * $p_limit;
} else {
if ($gfilter == "investment_orgs") {
$i_limit = $limit;
//person limit
$i_start = $start / $limit * $i_limit;
} else {
$c_limit = floor($limit / 3) + $limit % 3;
//company limit
$p_limit = floor($limit / 3);
//person limit
$i_limit = floor($limit / 3);
//investment org limit
$c_start = $start / $limit * $c_limit;
$p_start = $start / $limit * $p_limit;
$i_start = $start / $limit * $i_limit;
}
}
}
if ($gfilter == 'newlyadded') {
$filter = "UNIX_TIMESTAMP(`dateadded`)>" . (time() - 5 * 24 * 60 * 60) . "";
//within 5 days
$gfilter = "";
} else {
if ($gfilter == 'newlyupdated') {
$filter = "UNIX_TIMESTAMP(`dateupdated`)>" . (time() - 5 * 24 * 60 * 60) . "";
//within 5 days
$gfilter = "";
} else {
$filter = 1;
}
}
$totalcnt = 0;
$results = array();
$thecnt = 0;
$results['results'] = array();
//counts
if ($gfilter == "" || $gfilter == "companies") {
$table = "companies";
$sql = "select count(`id`) as `cnt` from `" . $table . "` where \n\t\t\t\t(\n\t\t\t\t\t";
if ($exact == 'country') {
$sql .= "\n\t\t\t\t\t\tLOWER(`" . $exact . "`) = '" . mysql_real_escape_string($search2) . "'";
} else {
if ($exact == 'category') {
$sql .= "\n\t\t\t\t\t\t`id` in (select `company_id` from `company_category` where `category_id`='" . mysql_real_escape_string($search2) . "')";
} else {
$sql .= "\n\t\t\t\t\t\tLOWER(`name`) like '%" . mysql_real_escape_string($search) . "%' or\n\t\t\t\t\t\tLOWER(`twitter_username`) like '%" . mysql_real_escape_string($search) . "%' or\n\t\t\t\t\t\tLOWER(`website`) like '%" . mysql_real_escape_string($search) . "%' or\n\t\t\t\t\t\tLOWER(`blog`) like '%" . mysql_real_escape_string($search) . "%' or \n\t\t\t\t\t\tLOWER(`facebook`) like '%" . mysql_real_escape_string($search) . "%' or \n\t\t\t\t\t\tLOWER(`linkedin`) like '%" . mysql_real_escape_string($search) . "%' or \n\t\t\t\t\t\tLOWER(`description`) like '%" . mysql_real_escape_string($search) . "%' or \n\t\t\t\t\t\tLOWER(`country`) like '%" . mysql_real_escape_string($search) . "%' or\n\t\t\t\t\t\tLOWER(`tags`) like '%" . mysql_real_escape_string($search) . "%' or\n\t\t\t\t\t\t`id` in ( select `company_id` from `company_category` where `category_id` in (select `id` from `categories` where `category` = '" . mysql_real_escape_string($search) . "') )\n\t\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t";
}
}
$sql .= "\n\t\t\t\t)\n\t\t\t\tand\n\t\t\t\t(\n\t\t\t\t\t" . $filter . "\n\t\t\t\t\tand `active`=1\n\t\t\t\t)";
$q = $this->db->query($sql);
$cnt = $q->result_array();
$c_cnt = $cnt[0]['cnt'];
$thecnt += $c_cnt;
}
if ($gfilter == "" || $gfilter == "people") {
$table = "people";
$sql = "select count(`id`) as `cnt` from `" . $table . "` where \n\t\t\t\t(\n\t\t\t\t\t";
if ($exact == 'country') {
$sql .= "0";
} else {
if ($exact == 'category') {
$sql .= "0";
} else {
$sql .= "\n\t\t\t\t\t\tLOWER(`name`) like '%" . mysql_real_escape_string($search) . "%' or\n\t\t\t\t\t\tLOWER(`twitter_username`) like '%" . mysql_real_escape_string($search) . "%' or\n\t\t\t\t\t\tLOWER(`blog`) like '%" . mysql_real_escape_string($search) . "%' or \n\t\t\t\t\t\tLOWER(`facebook`) like '%" . mysql_real_escape_string($search) . "%' or \n\t\t\t\t\t\tLOWER(`linkedin`) like '%" . mysql_real_escape_string($search) . "%' or \n\t\t\t\t\t\tLOWER(`description`) like '%" . mysql_real_escape_string($search) . "%' or \n\t\t\t\t\t\tLOWER(`tags`) like '%" . mysql_real_escape_string($search) . "%'";
}
}
$sql .= "\n\t\t\t\t)\n\t\t\t\tand\n\t\t\t\t(\n\t\t\t\t\t" . $filter . "\n\t\t\t\t\tand `active`=1\n\t\t\t\t)";
$q = $this->db->query($sql);
$cnt = $q->result_array();
$p_cnt = $cnt[0]['cnt'];
$thecnt += $p_cnt;
}
if ($gfilter == "" || $gfilter == "investment_orgs") {
$table = "investment_orgs";
$sql = "select count(`id`) as `cnt` from `" . $table . "` where \n\t\t\t\t(\n\t\t\t\t\t";
if ($exact == 'country') {
$sql .= "\n\t\t\t\t\t\tLOWER(`" . $exact . "`) = '" . mysql_real_escape_string($search2) . "'";
} else {
if ($exact == 'category') {
$sql .= "0";
} else {
$sql .= "\n\t\t\t\t\t\tLOWER(`name`) like '%" . mysql_real_escape_string($search) . "%' or\n\t\t\t\t\t\tLOWER(`twitter_username`) like '%" . mysql_real_escape_string($search) . "%' or\n\t\t\t\t\t\tLOWER(`website`) like '%" . mysql_real_escape_string($search) . "%' or\n\t\t\t\t\t\tLOWER(`blog`) like '%" . mysql_real_escape_string($search) . "%' or \n\t\t\t\t\t\tLOWER(`facebook`) like '%" . mysql_real_escape_string($search) . "%' or \n\t\t\t\t\t\tLOWER(`linkedin`) like '%" . mysql_real_escape_string($search) . "%' or \n\t\t\t\t\t\tLOWER(`description`) like '%" . mysql_real_escape_string($search) . "%' or \n\t\t\t\t\t\tLOWER(`tags`) like '%" . mysql_real_escape_string($search) . "%'";
}
}
$sql .= "\n\t\t\t\t)\n\t\t\t\tand\n\t\t\t\t(\n\t\t\t\t\t" . $filter . "\n\t\t\t\t\tand `active`=1\n\t\t\t\t)";
$q = $this->db->query($sql);
$cnt = $q->result_array();
$i_cnt = $cnt[0]['cnt'];
$thecnt += $i_cnt;
}
//start controller
$remain['c_limit'] = $c_cnt - ($c_start + $c_limit);
$remain['p_limit'] = $p_cnt - ($p_start + $p_limit);
$remain['i_limit'] = $i_cnt - ($i_start + $i_limit);
$distribute = 0;
$distcount = 3;
// distribute cout
foreach ($remain as $key => $value) {
if ($value <= 0) {
$distribute += ${$key};
$distcount--;
}
}
//sort($remain, SORT_NUMERIC);
//echo "<pre>";
//echo $distribute;
//print_r($remain);
//data
if ($gfilter == "" || $gfilter == "companies") {
//companies
$table = "companies";
${$table} = array();
$results[$table] = array();
$sql = "select * from `" . $table . "` where \n\t\t\t\t(\n\t\t\t\t\t";
if ($exact == 'country') {
$sql .= "\n\t\t\t\t\t\tLOWER(`" . $exact . "`) = '" . mysql_real_escape_string($search2) . "'";
} else {
if ($exact == 'category') {
$sql .= "\n\t\t\t\t\t\t`id` in (select `company_id` from `company_category` where `category_id`='" . mysql_real_escape_string($search2) . "')";
} else {
$sql .= "\n\t\t\t\t\t\tLOWER(`name`) like '%" . mysql_real_escape_string($search) . "%' or\n\t\t\t\t\t\tLOWER(`twitter_username`) like '%" . mysql_real_escape_string($search) . "%' or\n\t\t\t\t\t\tLOWER(`website`) like '%" . mysql_real_escape_string($search) . "%' or\n\t\t\t\t\t\tLOWER(`blog`) like '%" . mysql_real_escape_string($search) . "%' or \n\t\t\t\t\t\tLOWER(`facebook`) like '%" . mysql_real_escape_string($search) . "%' or \n\t\t\t\t\t\tLOWER(`linkedin`) like '%" . mysql_real_escape_string($search) . "%' or \n\t\t\t\t\t\tLOWER(`description`) like '%" . mysql_real_escape_string($search) . "%' or \n\t\t\t\t\t\tLOWER(`country`) like '%" . mysql_real_escape_string($search) . "%' or\n\t\t\t\t\t\tLOWER(`tags`) like '%" . mysql_real_escape_string($search) . "%' or\n\t\t\t\t\t\t`id` in ( select `company_id` from `company_category` where `category_id` in (select `id` from `categories` where `category` = '" . mysql_real_escape_string($search) . "') )\n\t\t\t\t\t\t";
}
}
$sql .= "\n\t\t\t\t)\n\t\t\t\tand\n\t\t\t\t(\n\t\t\t\t\t" . $filter . "\n\t\t\t\t\tand `active`=1\n\t\t\t\t)\n\t\t\torder by `name` asc limit {$c_start}, {$c_limit}";
$q = $this->db->query($sql);
${$table} = $q->result_array();
//echo $sql;
//print_r($companies);
$temparr = array();
$resultstemp = ${$table};
$t = count($resultstemp);
//remove same results
for ($i = 0; $i < $t; $i++) {
$value = $resultstemp[$i];
if (!in_array($value['id'], $temparr)) {
$temparr[] = $value['id'];
//echo $search, " ", $resultstemp[$i]['name'], " ", abs(strcasecmp($search, $resultstemp[$i]['name'])), "<br>";
$resultstemp[$i]['name_score'] = $this->nameScore($search, $resultstemp[$i]['name']);
$resultstemp[$i]['table'] = $table;
} else {
unset($resultstemp[$i]);
}
}
$resultstemp = array_values($resultstemp);
$results[$table]['cnt'] = $t;
$totalcnt += $results[$table]['cnt'];
$results[$table]['results'] = $resultstemp;
$results['results'] = array_merge($results['results'], $resultstemp);
}
if ($gfilter == "" || $gfilter == "people") {
//people
$table = "people";
${$table} = array();
$results[$table] = array();
$sql = "select * from `" . $table . "` where \n\t\t\t\t(\n\t\t\t\t\t";
if ($exact == 'country') {
$sql .= "0";
} else {
if ($exact == 'category') {
$sql .= "0";
} else {
$sql .= "\n\t\t\t\t\t\tLOWER(`name`) like '%" . mysql_real_escape_string($search) . "%' or\n\t\t\t\t\t\tLOWER(`twitter_username`) like '%" . mysql_real_escape_string($search) . "%' or\n\t\t\t\t\t\tLOWER(`blog`) like '%" . mysql_real_escape_string($search) . "%' or \n\t\t\t\t\t\tLOWER(`facebook`) like '%" . mysql_real_escape_string($search) . "%' or \n\t\t\t\t\t\tLOWER(`linkedin`) like '%" . mysql_real_escape_string($search) . "%' or \n\t\t\t\t\t\tLOWER(`description`) like '%" . mysql_real_escape_string($search) . "%' or \n\t\t\t\t\t\tLOWER(`tags`) like '%" . mysql_real_escape_string($search) . "%'";
}
}
$sql .= "\n\t\t\t\t)\n\t\t\t\tand\n\t\t\t\t(\n\t\t\t\t\t" . $filter . "\n\t\t\t\t\tand `active`=1\n\t\t\t\t)\n\t\t\torder by `name` asc limit {$p_start}, {$p_limit}";
$q = $this->db->query($sql);
${$table} = $q->result_array();
$temparr = array();
$resultstemp = ${$table};
$t = count($resultstemp);
//remove same results
for ($i = 0; $i < $t; $i++) {
$value = $resultstemp[$i];
if (!in_array($value['id'], $temparr)) {
$temparr[] = $value['id'];
//echo $search, " ", $resultstemp[$i]['name'], " ", abs(strcasecmp($search, $resultstemp[$i]['name'])), "<br>";
$resultstemp[$i]['name_score'] = $this->nameScore($search, $resultstemp[$i]['name']);
$resultstemp[$i]['table'] = $table;
} else {
unset($resultstemp[$i]);
}
}
$resultstemp = array_values($resultstemp);
$results[$table]['cnt'] = $t;
$totalcnt += $results[$table]['cnt'];
$results[$table]['results'] = $resultstemp;
$results['results'] = array_merge($results['results'], $resultstemp);
}
if ($gfilter == "" || $gfilter == "investment_orgs") {
//investment_orgs
$table = "investment_orgs";
${$table} = array();
$results[$table] = array();
$sql = "select * from `" . $table . "` where \n\t\t\t\t(\n\t\t\t\t\t";
if ($exact == 'country') {
$sql .= "\n\t\t\t\t\t\tLOWER(`" . $exact . "`) = '" . mysql_real_escape_string($search2) . "'";
} else {
if ($exact == 'category') {
$sql .= "0";
} else {
$sql .= "\n\t\t\t\t\t\tLOWER(`name`) like '%" . mysql_real_escape_string($search) . "%' or\n\t\t\t\t\t\tLOWER(`twitter_username`) like '%" . mysql_real_escape_string($search) . "%' or\n\t\t\t\t\t\tLOWER(`website`) like '%" . mysql_real_escape_string($search) . "%' or\n\t\t\t\t\t\tLOWER(`blog`) like '%" . mysql_real_escape_string($search) . "%' or \n\t\t\t\t\t\tLOWER(`facebook`) like '%" . mysql_real_escape_string($search) . "%' or \n\t\t\t\t\t\tLOWER(`linkedin`) like '%" . mysql_real_escape_string($search) . "%' or \n\t\t\t\t\t\tLOWER(`description`) like '%" . mysql_real_escape_string($search) . "%' or \n\t\t\t\t\t\tLOWER(`tags`) like '%" . mysql_real_escape_string($search) . "%'";
}
}
$sql .= "\n\t\t\t\t)\n\t\t\t\tand\n\t\t\t\t(\n\t\t\t\t\t" . $filter . "\n\t\t\t\t\tand `active`=1\n\t\t\t\t)\n\t\t\torder by `name` asc limit {$i_start}, {$i_limit}";
$q = $this->db->query($sql);
${$table} = $q->result_array();
$temparr = array();
$resultstemp = ${$table};
$t = count($resultstemp);
//remove same results
for ($i = 0; $i < $t; $i++) {
$value = $resultstemp[$i];
if (!in_array($value['id'], $temparr)) {
$temparr[] = $value['id'];
//echo $search, " ", $resultstemp[$i]['name'], " ", abs(strcasecmp($search, $resultstemp[$i]['name'])), "<br>";
$resultstemp[$i]['name_score'] = $this->nameScore($search, $resultstemp[$i]['name']);
$resultstemp[$i]['table'] = $table;
} else {
unset($resultstemp[$i]);
}
}
$resultstemp = array_values($resultstemp);
$results[$table]['cnt'] = $t;
$totalcnt += $results[$table]['cnt'];
$results[$table]['results'] = $resultstemp;
$results['results'] = array_merge($results['results'], $resultstemp);
}
$results['results'] = $this->sortResults($results['results']);
$results['totalcnt'] = $totalcnt;
$_SESSION['search_results'] = $results;
//echo "<pre>";
//print_r($results);
$data['results'] = $results;
$data['thecnt'] = $thecnt;
$data['start'] = $start;
$data['c_limit'] = $c_limit;
$data['p_limit'] = $p_limit;
$data['i_limit'] = $i_limit;
$data['c_start'] = $c_start;
$data['p_start'] = $p_start;
$data['i_start'] = $i_start;
$data['limit'] = $limit;
$data['search'] = $searchx;
$data['newlyfunded'] = $this->newlyFunded();
$data['categoriesCount'] = $this->categoriesCount();
$data['content'] = $this->load->view('startuplist/search', $data, true);
$this->load->view('startuplist/main', $data);
}
