function getAll($tableName, $tagsTable, $max = 100, $page = 0, $params = array(), $cacheTime = 900) { $status = !empty($params['status']) ? (int) $params['status'] : 1; $searchTerm = !empty($params['q']) ? $params['q'] : ''; $lat = !empty($params['lat']) ? $params['lat'] : ''; $lon = !empty($params['lon']) ? $params['lon'] : ''; $radius = !empty($params['radius']) ? $params['radius'] : 30; $path = !empty($params['path']) ? $params['path'] : null; $distance = ''; $distanceWhere = ''; $order = ' ORDER BY a.id DESC'; if (!empty($lat) && !empty($lon)) { $distance = ", (ROUND(\n\tDEGREES(ACOS(SIN(RADIANS(" . GetSQLValueString($lat, 'double') . ")) * SIN(RADIANS(a.lat)) + COS(RADIANS(" . GetSQLValueString($lat, 'double') . ")) * COS(RADIANS(a.lat)) * COS(RADIANS(" . GetSQLValueString($lon, 'double') . " -(a.lng)))))*60*1.1515,2)) as distance"; $distanceWhere = " AND (ROUND(\n\tDEGREES(ACOS(SIN(RADIANS(" . GetSQLValueString($lat, 'double') . ")) * SIN(RADIANS(a.lat)) + COS(RADIANS(" . GetSQLValueString($lat, 'double') . ")) * COS(RADIANS(a.lat)) * COS(RADIANS(" . GetSQLValueString($lon, 'double') . " -(a.lng)))))*60*1.1515,2)) <= " . GetSQLValueString($radius, 'double'); $order = ' ORDER BY distance ASC'; } $Models_General = new Models_General(); //$Models_General->setDebug(1); $page = (int) $page; $maxRows_rsView = $max; $pageNum_rsView = $page; $startRow_rsView = $pageNum_rsView * $maxRows_rsView; $query_rsView = 'select *, a.id as id ' . $distance . ' FROM ' . $tableName . ' as a LEFT JOIN ' . $tagsTable . ' as b ON a.id = b.id WHERE a.status = ' . $status . ' AND a.deleted = 0' . $distanceWhere; if (!empty($searchTerm)) { $query_rsView .= ' AND b.tag LIKE ' . $Models_General->qstr('%' . $searchTerm . '%'); } if (!empty($path)) { $query_rsView .= ' AND a.path = ' . $Models_General->qstr($path); } if (!empty($params['uid'])) { $query_rsView .= ' AND a.uid = ' . $Models_General->qstr($params['uid']); } if (!empty($params['i1'])) { $query_rsView .= ' AND a.i1 = ' . $Models_General->qstr($params['i1']); } if (!empty($params['i2'])) { $query_rsView .= ' AND a.i2 = ' . $Models_General->qstr($params['i2']); } if (!empty($params['d1'])) { $query_rsView .= ' AND a.d1 = ' . $Models_General->qstr($params['d1']); } if (!empty($params['d2'])) { $query_rsView .= ' AND a.d2 = ' . $Models_General->qstr($params['d2']); } if (!empty($params['vc1'])) { $query_rsView .= ' AND a.vc1 = ' . $Models_General->qstr($params['vc1']); } if (!empty($params['vc2'])) { $query_rsView .= ' AND a.vc2 = ' . $Models_General->qstr($params['vc2']); } if (!empty($params['t1'])) { $query_rsView .= ' AND a.t1 LIKE ' . $Models_General->qstr('%' . $params['t1'] . '%'); } if (!empty($params['t2'])) { $query_rsView .= ' AND a.t2 = ' . $Models_General->qstr($params['t2']); } $query_rsView .= ' GROUP BY a.id'; $query_rsView .= $order; $query_limit_rsView = sprintf("%s LIMIT %d, %d", $query_rsView, $startRow_rsView, $maxRows_rsView); $results = $Models_General->fetchAll($query_limit_rsView, array(), $cacheTime); $queryTotalRows = 'select COUNT(distinct a.id) AS cnt FROM ' . $tableName . ' as a LEFT JOIN ' . $tagsTable . ' as b ON a.id = b.id WHERE a.status = ' . $status . ' AND a.deleted = 0' . $distanceWhere; if (!empty($searchTerm)) { $queryTotalRows .= ' AND b.tag LIKE ' . $Models_General->qstr('%' . $searchTerm . '%'); } if (!empty($path)) { $queryTotalRows .= ' AND a.path = ' . $Models_General->qstr($path); } if (!empty($params['uid'])) { $queryTotalRows .= ' AND a.uid = ' . $Models_General->qstr($params['uid']); } if (!empty($params['i1'])) { $queryTotalRows .= ' AND a.i1 = ' . $Models_General->qstr($params['i1']); } if (!empty($params['i2'])) { $queryTotalRows .= ' AND a.i2 = ' . $Models_General->qstr($params['i2']); } if (!empty($params['d1'])) { $queryTotalRows .= ' AND a.d1 = ' . $Models_General->qstr($params['d1']); } if (!empty($params['d2'])) { $queryTotalRows .= ' AND a.d2 = ' . $Models_General->qstr($params['d2']); } if (!empty($params['vc1'])) { $queryTotalRows .= ' AND a.vc1 = ' . $Models_General->qstr($params['vc1']); } if (!empty($params['vc2'])) { $queryTotalRows .= ' AND a.vc2 = ' . $Models_General->qstr($params['vc2']); } if (!empty($params['t1'])) { $queryTotalRows .= ' AND a.t1 LIKE ' . $Models_General->qstr('%' . $params['t1'] . '%'); } if (!empty($params['t2'])) { $queryTotalRows .= ' AND a.t2 = ' . $Models_General->qstr($params['t2']); } $rowCountResult = $Models_General->fetchRow($queryTotalRows, array(), $cacheTime); $totalRows_rsView = $rowCountResult['cnt']; $totalPages_rsView = ceil($totalRows_rsView / $maxRows_rsView) - 1; $return = array('results' => $results, 'max' => $max, 'page' => $page, 'totalRows' => $totalRows_rsView, 'totalPages' => $totalPages_rsView, 'start' => $startRow_rsView, 'pageNum_rsView' => $pageNum_rsView, 'params' => $params); return $return; }
$insertError = 'Please choose after work image'; } } if (empty($insertError)) { $arr = array(); $arr['before_image'] = 's' . time() . '_b_' . $_FILES['beforeFile']['name']; $arr['after_image'] = 's' . time() . '_a_' . $_FILES['afterFile']['name']; move_uploaded_file($_FILES['beforeFile']['tmp_name'], '../images/' . $arr['before_image']); move_uploaded_file($_FILES['afterFile']['tmp_name'], '../images/' . $arr['after_image']); $Models_General->addDetails('works', $arr); $insertError = 'Record Added Successfully'; } } if (isset($_GET['delete'])) { $query_rsView = 'select * FROM works WHERE work_id = ?'; $rs = $Models_General->fetchRow($query_rsView, array($_GET['id']), 0); if ($rs) { $query_rsView = 'delete FROM works WHERE work_id = ?'; $Models_General->deleteDetails($query_rsView, array($_GET['id'])); if (file_exists('../images/' . $rs['before_image'])) { unlink('../images/' . $rs['before_image']); } if (file_exists('../images/' . $rs['after_image'])) { unlink('../images/' . $rs['after_image']); } } } $data = $Models_General->work($max, $page, 0); $totalRows_rsView = isset($data['totalRows']) ? $data['totalRows'] : 0; $totalPages_rsView = isset($data['totalPages']) ? $data['totalPages'] : 0; $queryString_rsView = "";