extjs 由浅入深 code

<?php class Images { function load($data){ $db = new SQLiteDatabase("sql/imgorg.db"); $tags = $data->tags; $album = $data->album; $qry = 'select i.filename as filename, i.url as url, i.id as id from Images i'; $where = array(); if ($tags) { for ($i = 0;$i < sizeof($tags);$i++) { $qry .= ' INNER JOIN Images_Tags it'.$i.' ON i.id = it'.$i.'.image_id'; array_push($where,' it'.$i.'.tag_id = "'.$tags[$i].'"'); } } if ($album) { $qry .= ' INNER JOIN Albums a ON i.album_id = a.id'; array_push($where, ' a.id ="'.$album.'"'); } if ($where) { $qry .= ' WHERE'.join(" AND", $where); } $res = $db->query($qry); return $res->fetchAll(); // return $qry; } function upload($data, $files){ $name = $files["Filedata"]["name"]; $db = new SQLiteDatabase("sql/imgorg.db"); $db->queryExec('INSERT INTO Images (filename, url) VALUES("'.$name.'","images/'.$name.'")'); $q = $db->query('SELECT * FROM Images WHERE filename = "'.$name.'"'); move_uploaded_file($files["Filedata"]["tmp_name"],"../images/".$name); return array( 'data' => $files["Filedata"], 'res' => $q->fetchObject() //, //'test' => $phm->getImageQuality() ); } function addToAlbum($data) { $images = $data->images; $album = $data->album; $db = new SQLiteDatabase("sql/imgorg.db"); for ($i = 0;$i < sizeof($images);$i++) { // $db->queryExec('INSERT INTO Albums_Images (image_id, album_id) VALUES ("'.$images[$i].'","'.$album.'")'); $db->queryExec('UPDATE Images SET album_id = "'.$album.'" WHERE id ="'.$images[$i].'"'); } return array('success' => true, 'images' => $images, 'album' => $album); } function tagImage($data) { $images = $data->images; $tag = $data->tag; $db = new SQLiteDatabase("sql/imgorg.db"); // if it is a known tag the id is sent, otherwise a new string is, so we need to insert if (!is_numeric($tag)) { $db->queryExec('INSERT INTO Tags (text) VALUES ("'.$tag.'")'); $q = $db->query('SELECT id FROM Tags WHERE text = "'.$tag.'"'); $tag = $q->fetchObject()->id; } for ($i = 0;$i < sizeof($images);$i++) { $db->queryExec('INSERT INTO Images_Tags (image_id, tag_id) VALUES ("'.$images[$i].'","'.$tag.'")'); } return array('success' => true, 'images' => $images, 'tag' => $tag); } function rename($data) { $db = new SQLiteDatabase("sql/imgorg.db"); $image = $data->image; $name = $data->name; $url = $data->url; $urls = split('/',$url); array_pop($urls); $newUrl = (join('/',$urls)).'/'.$name; $db->queryExec('UPDATE Images SET url = "'.$newUrl.'", filename = "'.$name.'" WHERE id = "'.$image.'"'); rename('../'.$url, '../'.$newUrl); return array('image' => $image, 'name' => $name, 'url' => $newUrl); } function remove($data) { $db = new SQLiteDatabase("sql/imgorg.db"); $images = $data->images; for ($i = 0;$i < sizeof($images);$i++) { $res = $db->query('SELECT url FROM Images where id ="'.$images[$i].'"'); $url = $res->fetchObject()->url; unlink('../'.$url); $db->queryExec('DELETE FROM Images WHERE id ="'.$images[$i].'"'); $db->queryExec('DELETE FROM Images_Tags WHERE image_id ="'.$images[$i].'"'); } } function getInfo($data) { $db = new SQLiteDatabase("sql/imgorg.db"); $image = $data->image; $q = $db->query('SELECT url FROM Images WHERE id = "'.$image.'"'); $path = $q->fetchObject()->url; $ret = exif_read_data('../'.$path); return $ret; } }