<?php
/**
***************************************************************************************************
 * @Software    AjaxMint Gallery
 * @Author      Rajapandian - hide@address.com
 * @Copyright   Copyright (c) 2010-2011. All Rights Reserved.
 * @License     GNU GENERAL PUBLIC LICENSE
 **************************************************************************************************
 This source code is licensed under the terms of the GNU GENERAL PUBLIC LICENSE
 http://www.gnu.org/licenses/gpl.html
 **************************************************************************************************
 Copyright (c) 2010-2011 http://ajaxmint.com. All Rights Reserved.
 **************************************************************************************************
**/

class ModelPictures extends Model {

    function __construct() {
        $this->load->helper('pictures');
        $this->p_helper = new HelperPictures();	
    }
    
    function getPictures($album_id,$offset,$per_page,$gallery_id) {
        return $this->p_helper->getPictures($album_id,$offset,$per_page,$gallery_id);
    }
    
    function order($orderAr){
        $record_start = $this->request->post['record_start'];
        foreach($orderAr as $key=>$val) {
            $this->db->query("update
                    ".$this->table." 
                    set sortorder='".($record_start+$key+1)."' 
                    where picture_id='".$val."'");
        }
    }

    function getPicture($picture_id) {            
        $result = $this->db->query("SELECT * FROM ".$this->table." where picture_id='".$picture_id."'");
        return $result->row;                    
    }
    
    function deletePicture($picture_id) {
            
        $result = $this->db->query("SELECT * FROM ".$this->table." where picture_id='".$picture_id."'");
        removeimage($result->row['image']);
        return $this->db->query("delete FROM ".$this->table." where picture_id='".$picture_id."'");    
    }
    
    function totalPictures($album_id,$gallery_id) {
        return $this->p_helper->totalPictures($album_id,$gallery_id);
    }
    
    function savePicture($fvalue) {            
            
        if($fvalue['picture_id']) {
            $beginString = " update ".$this->table." set ";
            $endString = " where    picture_id='".$fvalue['picture_id']."' ";
        }else {
            $beginString = "insert into ".$this->table." set";
            $endString = " ,date_added=NOW()";
        }
        
        if($fvalue['image']) $imgCon = ", image='".$fvalue['image']."'";
        
        $result = $this->db->query($beginString." 
                title='".$fvalue['title']."',
                album_id='".$fvalue['album_id']."',
                date_updated=NOW(),
                description='".$fvalue['description']."'
                $imgCon "
                .$endString
        );    

        $this->db->query("update ".DB_PREFIX."albums 
                    set pictures=(select count(picture_id)
                    from 
                    ".$this->table."
                    where album_id='".$fvalue['album_id']."'
                    )
                    where album_id='".$fvalue['album_id']."'");    
        
        return $fvalue;
        
    }
}