Changeset 30702 for extensions/manage_properties_photos/include

Timestamp:

Dec 6, 2014, 8:32:09 AM (10 years ago)

Author:

ddtddt

Message:

[extensions] - manage_properties_photos -beta 4

File:

• extensions/manage_properties_photos/include/function.aip.inc.php (modified) (2 diffs)

extensions/manage_properties_photos/include/function.aip.inc.php

@@ -1 +1 @@
 <?php 
+/*picture*/
 function tab_add_info_one_photo($id_img){
 $query = '
-    SELECT aip.id_info_pho,aip.designation,aipd.data,aip.orderinfo
-    FROM ' . ADD_INFO_PHOTO_TABLE . ' AS aip
-    LEFT JOIN ' . ADD_INFO_PHOTO_DATA_TABLE . ' AS aipd ON aip.id_info_pho=aipd.id_info_pho
+    SELECT aip.id_prop_pho,aip.wording,aipd.data,aip.orderprop
+    FROM ' . ADD_PROP_PHOTO_TABLE . ' AS aip
+    LEFT JOIN ' . ADD_PROP_PHOTO_DATA_TABLE . ' AS aipd ON aip.id_prop_pho=aipd.id_prop_pho
     WHERE aipd.id_img = \'' . $id_img . '\' 
     AND aip.active = 0 
-    ORDER BY aip.orderinfo ASC
+    ORDER BY aip.orderprop ASC
     ;';
 
 return pwg_query($query);
 }
-
+/*
 function tab_add_info_one_photo2($id_img){
 $query = '
-    SELECT aip.id_info_pho,aip.designation,aipd.data,aip.orderinfo
-    FROM ' . ADD_INFO_PHOTO_DATA_TABLE . ' AS aipd
-    RIGHT JOIN ' . ADD_INFO_PHOTO_TABLE . ' AS aip ON aip.id_info_pho=aipd.id_info_pho
+    SELECT aip.id_prop_pho,aip.wording,aipd.data,aip.orderprop
+    FROM ' . ADD_PROP_PHOTO_DATA_TABLE . ' AS aipd
+    RIGHT JOIN ' . ADD_PROP_PHOTO_TABLE . ' AS aip ON aip.id_prop_pho=aipd.id_prop_pho
     WHERE aipd.id_img = \'' . $id_img . '\' 
     AND aip.active = 0 
-    ORDER BY aip.orderinfo ASC
+    ORDER BY aip.orderprop ASC
     ;';
 
 return pwg_query($query);
 }
-
+*/
+/*Admin*/
 function tab_add_info_by_photo(){
 $query = '
-    SELECT id_info_pho,designation
-    FROM ' . ADD_INFO_PHOTO_TABLE . ' 
+    SELECT id_prop_pho,wording
+    FROM ' . ADD_PROP_PHOTO_TABLE . ' 
     WHERE active = 0 
     AND edit = 1 
-    ORDER BY orderinfo ASC
+    ORDER BY orderprop ASC
     ;';
 return pwg_query($query);
 }
 
+
+/*initpicture*/
 function tab_add_info_by_photo_show(){
 $query = '
-    SELECT id_info_pho,designation,orderinfo
-    FROM ' . ADD_INFO_PHOTO_TABLE . ' 
+    SELECT id_prop_pho,wording,orderprop
+    FROM ' . ADD_PROP_PHOTO_TABLE . ' 
     WHERE active = 0 
-    ORDER BY orderinfo ASC
+    ORDER BY orderprop ASC
     ;';
 return pwg_query($query);
 }
 
-function data_info_photos($id_img=null,$id_info_pho=NULL){
+/*initpicture et admin*/
+function data_info_photos($id_img=null,$id_prop_pho=NULL){
 $query = '
     SELECT data
-    FROM ' . ADD_INFO_PHOTO_DATA_TABLE;
+    FROM ' . ADD_PROP_PHOTO_DATA_TABLE;
     $wa='WHERE';
     if($id_img!=null){
         $query .=' '.$wa.' id_img='.$id_img;$wa='AND';
     }
-    if($id_info_pho!=null){
-        $query .=' '.$wa.' id_info_pho='.$id_info_pho;$wa='AND';
+    if($id_prop_pho!=null){
+        $query .=' '.$wa.' id_prop_pho='.$id_prop_pho;$wa='AND';
     }
 $query .= ';';
@@ -62 +67 @@
 }
 
-
-function tab_info_photos($id_info_pho=NULL){
+/*Admin*/
+function tab_info_photos($id_prop_pho=NULL){
 $query = '
-    SELECT id_info_pho,designation,orderinfo,active,edit
-    FROM ' . ADD_INFO_PHOTO_TABLE;
-    if($id_info_pho!=null){
-        $query .= ' WHERE id_info_pho='.$id_info_pho;
+    SELECT id_prop_pho,wording,orderprop,active,edit
+    FROM ' . ADD_PROP_PHOTO_TABLE;
+    if($id_prop_pho!=null){
+        $query .= ' WHERE id_prop_pho='.$id_prop_pho;
     }
 
-$query .= ' ORDER BY orderinfo ASC
+$query .= ' ORDER BY orderprop ASC
     ;';
 return pwg_query($query);