API tools faq
paste
Advertisement
Guest User

cek list

a guest
Dec 17th, 2014
186
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.60 KB | None | 0 0
raw download clone embed print report
  1. <?php header('Access-Control-Allow-Origin: *');
  2. ob_start();
  3. include("connexion.php");
  4. //clude("liste_connexion.php");
  5. $load_city="All";
  6. if(isset($_GET["load_city"])){
  7. $nom_parent=$_GET["nom_parent"];
  8. $nom=$_GET["nom"];
  9. $load_city=$load_city;
  10. $lg = $_GET["lg"];
  11. $latpos = $_GET["latpos"];
  12. $longpos = $_GET["longpos"];
  13. $apa = $_GET["apa"];
  14. $_SESSION['lg'] = $lg;
  15. }
  16. $num_enreg=0;
  17.  
  18. //récupération du titre des collonnes de la table correspondante
  19. $query = "SELECT * FROM ".$nom_parent.";" ;
  20. $result = mysql_query($query);
  21. $colonne_nom = mysql_field_name($result,1);
  22. $colonne_dossier = mysql_field_name($result,2);
  23.  
  24.  
  25. $result=array();
  26. $address = "";
  27. if ($load_city != "All") {
  28. $address = "AND LOWER(SUBSTR(e.address, LENGTH(SUBSTRING_INDEX(e.address, ' ', 2)))) REGEXP (
  29. SELECT LOWER(group_concat( city_synonyms.synonym_name
  30. SEPARATOR '|' ))
  31. FROM `city_synonyms`
  32. WHERE city_name LIKE '%".$load_city."%'
  33. )";
  34. };
  35. // else if($load_city != "All") {
  36. // $address = "AND LOWER( e.address ) REGEXP '".strtolower($load_city)."'";
  37. // }
  38.  
  39.  
  40. $complete=array();
  41. $compdistance=array();
  42. $t2="SELECT num_contrat, date_enreg ,picture, hit, latlong from entreprise where sscategorie='".$nom."';";
  43. $resultt=mysql_query($t2);
  44. if($resultt === FALSE) {
  45. die(mysql_error()); // TODO: better error handling
  46. }
  47. if ($latpos==0 && $longpos==0){
  48. }else {
  49. $lat=$latpos;
  50. $long=$longpos;
  51. }
  52.  
  53. function calculateDistance($latitude1, $longitude1, $latitude2, $longitude2) {
  54. $theta = $longitude1 - $longitude2;
  55. $miles = (sin(deg2rad($latitude1)) * sin(deg2rad($latitude2))) + (cos(deg2rad($latitude1)) * cos(deg2rad($latitude2)) * cos(deg2rad($theta)));
  56. $miles = acos($miles);
  57. $miles = rad2deg($miles);
  58. $miles = $miles * 60 * 1.1515;
  59. return $miles;
  60. }
  61.  
  62. while($arow=mysql_fetch_array($resultt)) {
  63. $tgl_now=date('Y-m-d');
  64. $ceklatlong=$arow['latlong'];
  65. $date1=$arow['date_enreg'];
  66. $asd=$date1;
  67. $numcont=$arow['num_contrat'];
  68. $q="SELECT datediff('".date('Y-m-d')."','$asd') AS DiffDate";
  69. $selisih=mysql_fetch_array(mysql_query($q));
  70. $hasil=$selisih['DiffDate']/30;
  71. if($hasil < 3){
  72. $point= 0;
  73. }else if($hasil < 6){
  74. $point= 1;
  75. }else if($hasil < 12){
  76. $point= 2;
  77. }else if($hasil < 24){
  78. $point= 3;
  79. }else if($hasil < 36){
  80. $point= 4;
  81. }else if($hasil > 36){
  82. $point= 5;
  83. }
  84. $hasilAkhir=$point*3;
  85.  
  86. $hit=$arow['hit'];
  87. $a=(int)$hit;
  88. if($a >=0 && $a<= 10){
  89. $point= 0;
  90. }else if($a < 50){
  91. $point= 1;
  92. }else if($a < 100){
  93. $point= 2;
  94. }else if($a < 500){
  95. $point= 3;
  96. }else if($a < 1000){
  97. $point= 4;
  98. }else if($a > 1000){
  99. $point= 5;
  100. }
  101. $stringHit = $point*5;
  102.  
  103. $identer=$arow['num_contrat'];
  104. $pic1=mysql_num_rows(mysql_query("select * from pictures where num_contrat='".$numcont."';"));
  105. if($pic1 == ''){
  106. $point= 0;
  107. }else if($pic1== 1){
  108. $point= 1;
  109. }else if($pic1 == 2){
  110. $point= 2;
  111. }else if($pic1 == 3){
  112. $point= 3;
  113. }else if($pic1 == 4){
  114. $point= 4;
  115. }else if($pic1 == 5){
  116. $point= 5;
  117. }
  118. $pic2 = $point*3;
  119.  
  120. $ads1=mysql_fetch_array(mysql_query("select * from pub where num_contrat='".$numcont."';"));
  121. $ads=$ads1['sscategorie'];
  122. if($ads ==''){
  123. $point= 0;
  124. }else if($ads > 0){
  125. $point= 1;
  126. }else if($ads =='index'){
  127. $point= 2;
  128. }else if($ads =='carrousel '){
  129. $point= 3;
  130. }else if($ads =='mainpage'){
  131. $point= 4;
  132. }else if($ads =='page'){
  133. $point= 5;
  134. }
  135. $pub = $point*2;
  136. $endpoint=$hasilAkhir+$stringHit+$pub+$pic2;
  137. $complete[]=$endpoint.".".$identer;
  138. if($latpos==0 && $longpos==0){
  139.  
  140. }else {
  141.  
  142. $point1_lat =$lat;
  143. $point1_lng =$long;
  144. $pecah=explode(",",$ceklatlong);
  145. $point2_lat=$pecah[0];
  146. $point2_lng=$pecah[1];
  147. $miles = calculateDistance($point1_lat, $point1_lng, $point2_lat,$point2_lng);
  148. $kilometers = $miles * 1.609344;
  149. $kms=$kilometers;
  150. $compdistance[]=round($kms,3).".".$identer;
  151. }
  152. }
  153. rsort($complete);
  154. natsort($compdistance);
  155. //echo "<pre>";print_r($complete);
  156. if($apa==0){
  157. foreach($compdistance as $datanya){
  158. $pisah=explode(".",$datanya);
  159. $hsil=$pisah[0];
  160. $numcontratid=$pisah[2];
  161. if ($latpos==0 && $longpos==0){
  162. $q2 = "SELECT *,
  163. IFNULL( CONCAT(p.file_path,'thm_',p.file_name), 'nophoto.jpg') AS 'primary_pic'
  164. FROM entreprise e
  165. LEFT JOIN pictures p ON e.num_contrat = p.num_contrat AND p.is_primary = 1
  166. WHERE e.sscategorie='".$nom."' AND e.num_contrat='".$numcontratid."' AND e.first='no' AND e.is_deleted=0 ".$address.";";
  167. } else {
  168. $q2 = "SELECT *,
  169. IFNULL( CONCAT(p.file_path,'thm_',p.file_name), 'nophoto.jpg') AS 'primary_pic'
  170. FROM entreprise e
  171. LEFT JOIN pictures p ON e.num_contrat = p.num_contrat AND p.is_primary = 1
  172. WHERE e.sscategorie='".$nom."' AND e.num_contrat='".$numcontratid."' AND e.is_deleted=0 ".$address.";";
  173. }
  174.  
  175. $q1 = "SELECT *,
  176. IFNULL( CONCAT(p.file_path,'thm_',p.file_name), 'nophoto.jpg') AS 'primary_pic'
  177. FROM entreprise e
  178. LEFT JOIN pictures p ON e.num_contrat = p.num_contrat AND p.is_primary = 1
  179. WHERE e.sscategorie='".$nom."' AND e.first='k' AND e.is_deleted=0 ".$address.";";
  180. $rs1 = mysql_query($q1);
  181. $num_rows1 = mysql_num_rows($rs1);
  182.  
  183. if ($num_rows1 > 0) {
  184. $tes = print_result($rs1, $lg, true);
  185. $result=array_merge($result, $tes);
  186. mysql_free_result($rs1);
  187. }
  188. $rs2 = mysql_query($q2);
  189. $num_rows2 = mysql_num_rows($rs2);
  190.  
  191. if ($num_rows2 > 0) {
  192. $tes2 = print_result($rs2, $lg, false);
  193. if(count($result)==0){
  194. $result=array_merge($result, $tes2);
  195. }
  196. else{
  197. $result[0] = $result[0].$tes2[0];
  198. $result[1] = array_merge($result[1], $tes2[1]);
  199. $result[2] = array_merge($result[2], $tes2[2]);
  200. $result[3] = array_merge($result[3], $tes2[3]);
  201. }
  202. mysql_free_result($rs2);
  203. }
  204. }
  205. }else if($apa==1) {
  206. foreach($complete as $datanya){
  207. $pisah=explode(".",$datanya);
  208. $hsil=$pisah[0];
  209. $numcontratid=$pisah[1];
  210. $q2 = "SELECT *,
  211. IFNULL( CONCAT(p.file_path,'thm_',p.file_name), 'nophoto.jpg') AS 'primary_pic'
  212. FROM entreprise e
  213. LEFT JOIN pictures p ON e.num_contrat = p.num_contrat AND p.is_primary = 1
  214. WHERE e.sscategorie='".$nom."' AND e.num_contrat='".$numcontratid."' AND e.first='no' AND e.is_deleted=0 ".$address.";";
  215. $q1 = "SELECT *,
  216. IFNULL( CONCAT(p.file_path,'thm_',p.file_name), 'nophoto.jpg') AS 'primary_pic'
  217. FROM entreprise e
  218. LEFT JOIN pictures p ON e.num_contrat = p.num_contrat AND p.is_primary = 1
  219. WHERE e.sscategorie='".$nom."' AND e.first='yes' AND e.is_deleted=0 ".$address.";";
  220. $rs1 = mysql_query($q1);
  221. $num_rows1 = mysql_num_rows($rs1);
  222.  
  223. if ($num_rows1 > 0) {
  224. $tes = print_result($rs1, $lg, true);
  225. $result=array_merge($result, $tes);
  226. mysql_free_result($rs1);
  227. }
  228. $rs2 = mysql_query($q2);
  229. $num_rows2 = mysql_num_rows($rs2);
  230.  
  231. if ($num_rows2 > 0) {
  232. $tes2 = print_result($rs2, $lg, false);
  233. if(count($result)==0){
  234. $result=array_merge($result, $tes2);
  235. }
  236. else{
  237. $result[0] = $result[0].$tes2[0];
  238. $result[1] = array_merge($result[1], $tes2[1]);
  239. $result[2] = array_merge($result[2], $tes2[2]);
  240. $result[3] = array_merge($result[3], $tes2[3]);
  241. }
  242.  
  243. mysql_free_result($rs2);
  244. }
  245. }
  246. }
  247. $all_result=array();
  248. function print_result($rs, $lg , $premier){
  249. $data_result="";
  250. $data_result1="";
  251. $latlong = array();
  252. $all_result = array();
  253. $nom_array = array();
  254. $num_id = array();
  255. $numrow=mysql_num_rows($rs);
  256. $x=-4;
  257. while ( $row = mysql_fetch_array($rs)) {
  258. if(++$x%10==0)
  259. {
  260. $data_result1 .= "<div class='box-business'>";
  261. $data_result1 .= "<img class='img-promo' src='../../images/are-you-in-horizontal.jpg'>";
  262. $data_result1 .= "</div>";
  263. }
  264. $tgl_now=date('Y-m-d');
  265. $latlong[] = $row['latlong'];
  266. $nom_array[] = $row['nom'];
  267. $num_id[]= $row['num'];
  268. if($premier)
  269. {
  270. $data_result .= "<div class='box-business-first'>";
  271. }
  272. else
  273. {
  274. $data_result .= "<div class='box-business'>";
  275. }
  276. $data_result .= "<div class='box-business-figure'>";
  277. $picUrl = "";
  278. if ( $row['primary_pic'] == "nophoto.jpg") {
  279. $picUrl = "../../img/thm_nophoto.jpg";
  280. } else {
  281. $picUrl = "../../" . $row['primary_pic'];
  282. }
  283. $data_result .= "<img src='".$picUrl."' alt='".$row['nom']."'>";
  284. $data_result .= "</div>";
  285. $data_result .= "<div class='box-business-info'>";
  286. $data_result .= "<div class='box-business-title'><h3>";
  287. $data_result .= "<a class='tsWhite' href='".$row['num'].".php";
  288. if($lg==2){$data_result .= "?lg=2";}
  289. $data_result .= "'>".$row['nom']."</a>".$row['num']."</h3></div>";
  290. $i=0;
  291. if ($row['hit']>0){$i++;}
  292. if ($row['hit']>10){$i++;}
  293. if ($row['hit']>100){$i++;}
  294. if ($row['hit']>1000){$i++;}
  295. $data_result .= "<div class='howhit'><img src='../../images/".$i."star.png' alt='Hit'/></div>";
  296. $data_result .= "<div class='box-business-description'>";
  297. if($lg==0){
  298. $chaine=$row['description'];
  299. }
  300. else {
  301. if ($row['description_en'] != ""){
  302. $chaine=$row['description_en'];
  303. }
  304. else{
  305. $chaine=$row['description'];
  306. }
  307. }
  308. $lg_max = 300; //nombre de caractère autoriser
  309. if (strlen($chaine) > $lg_max){
  310. $chaine = substr($chaine, 0, $lg_max);
  311. $last_space = strrpos($chaine, " ");
  312. $chaine = substr($chaine, 0, $last_space)."...";
  313. }
  314. $data_result .= $chaine;
  315. $data_result .= "</div>";
  316. $data_result .= "<div class='box-business-address'>";
  317. $substr=$row['address'];
  318. $subcekstr=strlen ($substr);
  319. if($subcekstr>50){
  320. $data_result .= "<span>".substr($row['address'],0,60)."..."."</span>";
  321. }else {
  322. $data_result .= "<span>".$row['address']."</span>";
  323. }
  324. $data_result .= "</div>";
  325. $data_result .= "<div class='box-business-telephone'>";
  326. $data_result .= "<a class='hoverbusines' href='".$row['num'].".php";
  327. if($lg==2){$data_result .= "?lg=2";}
  328. $data_result .= "'><span class='see'>";
  329. if($lg==2){
  330. $data_result .= "See More >>";
  331. }else{
  332. $data_result .= "Selengkapnya";
  333. }
  334. $data_result .= "</span></a></div>";
  335. $data_result .= "</div></div>" ;
  336.  
  337. }
  338. $all_result[0] = $data_result;
  339. $all_result[1] = $latlong;
  340. $all_result[2] = $nom_array;
  341. $all_result[3] = $num_id;
  342. $all_result[4] = $data_result1;
  343. return $all_result;
  344. }
  345. //echo "<pre>";print_r($all_data[1]);
  346. $result[0] .= '</div>';
  347. $json = json_encode($result);
  348. echo $json;
  349. exit();
  350. //echo isset($_GET['callback'])?"{$_GET['callback']}($json)": $json;
  351. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!