Changeset 11862 for lang/php/GohanLog/trunk/app/controllers/tags_controller.php

Timestamp:

05/18/08 13:04:06 (14 months ago)

Author:

kunitada

Message:

tag検索入れた

Files:

• lang/php/GohanLog/trunk/app/controllers/tags_controller.php (modified) (2 diffs)

lang/php/GohanLog/trunk/app/controllers/tags_controller.php

@@ -6 +6 @@
 
         var $helpers = array('Html','Form');
-        var $uses = array('Tag','User');
+        var $uses = array('Tag','User','Gohan');
     function add()
     {
@@ -42 +42 @@
     }
     function search()
-    {        
-        $q = $this->passed_args[0];
+    {
+        $q_urlencode = $this->passed_args[0];
+        $q = urldecode($q_urlencode);
+        
+        {
+            $conditions = 'where name='."'".$q."'";
+            $fields = '';
+            $order = '';
+            $tag_list = $this->Tag->findAll($conditions, $fields, $order, null, null);
+        }
+        $target_gohan_id_str = "";
+        foreach($tag_list as $k => $v){
+//            print "k=".$k;
+            if($k==0){
+                $target_gohan_id_str = $target_gohan_id_str."id=".$v['Tag']['target_id'];
+            }else{
+                $target_gohan_id_str = $target_gohan_id_str." OR id=".$v['Tag']['target_id'];
+            }
+        }
+//        print "target_gohan_id_str=".$target_gohan_id_str;
+
+        {
+            $conditions = 'where '.$target_gohan_id_str;
+            $fields = array('DISTINCT DATE_FORMAT(date_time_original, "%Y-%m-%d") date_time_originalYMD');
+            $order = 'date_time_original DESC';
+            $day_list = $this->Gohan->findAll($conditions, $fields, $order);
+        }
+        {
+            $gohans = array();
+            foreach($day_list as $value){
+                $date_time_originalYMD = $value[0]['date_time_originalYMD'];
+                $conditions = 'DATE_FORMAT(date_time_original, "%Y-%m-%d") = '."'$date_time_originalYMD'";
+                $fields = '';
+                $order = 'date_time_original ASC';
+                
+                $gohans[$date_time_originalYMD] = $this->Gohan->findAll($conditions, $fields, $order);
+            }
+        }
+        foreach ($gohans as $key => $value){
+            foreach($value as $key2 => $value2){
+                $id = $value2['Gohan']['id'];
+                $conditions = 'target_id = '."'$id'";
+                $fields = '';
+                $order = '';
+                $tags = $this->Tag->findAll($conditions, $fields, $order);
+                $gohans[$key][$key2]['Gohan']['tags'] = $tags;
+            }
+        }
+
+        $this->set('gohans', $gohans);
+        
     }