citywebshop_cms/application/models/admin_prods_model.php

<?php

class admin_prods_model extends Model {
    
    
    public function getBoxes() {
        $result = $this->query("select * from azonics_prods where box_status<>'0';");
        return $result;
    }
    
    
    public function loadBox() {
        $box_id = $this->escapeString($_REQUEST['id']);
        $row = $this->query("select * from azonics_prods where box_id='".$box_id."';");
        return $row[0];
    }
    
    
    public function saveBox() {
        $data = $this->escapeArray($_REQUEST);
        
        if ($data['box_id']!='') {
            $this->execute("update azonics_prods set "
                    . "box_title='".$data['box_title']."', "
                    . "box_title_en='".$data['box_title_en']."', "
                    . "parent_service='".$data['parent_service']."', "
                    . "parent_prods='".$data['parent_prods']."', "
                    . "box_subtitle='".$data['box_subtitle']."', "
                    . "box_subtitle_en='".$data['box_subtitle_en']."' "
                    . "where box_id='".$data['box_id']."';");
            
            return true;
        }
        else {
            $this->execute("insert into azonics_prods set "
                . "box_title='".$data['box_title']."', "
                . "box_title_en='".$data['box_title_en']."', "
                . "box_subtitle='".$data['box_subtitle']."', "
                . "box_subtitle_en='".$data['box_subtitle_en']."', "
                . "box_status='1', "
                . "parent_service='".$data['parent_service']."', "
                . "parent_prods='".$data['parent_prods']."', "
                . "box_user='".$_SESSION['admin_user']->admin_id."';");

            return true;
        }
    }
    
    
    public function deleteBox() {
        $box_id = $this->escapeString($_REQUEST['id']);
        $this->execute("update azonics_prods set box_status='0' where box_id='".$box_id."';");
        return true;
    }

    public function getPackageBlocks() {
        $result = $this->query("select * from azonics_prods_blocks where block_status<>'0' and box_id='".$_REQUEST['id']."' order by block_order asc;");
        return $result;
    }

    public function loadBlock($block_id) {
        $block_id = $this->escapeString($block_id);
        $row = $this->query("select * from azonics_prods_blocks where block_id='".$block_id."';");
        return $row[0];
    }

    public function updateBlock() {
        $data = $this->escapeArray($_REQUEST);
        
        if ($data['block_id']!='') {
            $this->execute("update azonics_prods_blocks set "
                    . "h1_text='".$data['h1_text']."', "
                    . "h2_text='".$data['h2_text']."', "
                    . "p_text='".$data['p_text']."', "
                    . "note_text='".$data['note_text']."' "
                    . "where block_id='".$data['block_id']."';");
            
            if ($_FILES['image_content']['tmp_name']!=='' && $data['block_type'] == 5) {
                $fname = 'banner_'.time().'.jpg';
                $path = 'static/uploads/thumbs/';
                move_uploaded_file($_FILES['image_content']['tmp_name'],$path.$fname);
                $this->execute("UPDATE azonics_prods_blocks SET image_content='".$path.$fname."' WHERE block_id='".$data['block_id']."';");
            }            
            return true;
        }
    }

    public function addBlock() {
        $data = $this->escapeArray($_REQUEST);

        $data['block_order'] = $this->getMaxBlockOrder() + 1;
        
        $this->execute("insert into azonics_prods_blocks set "
            . "box_id='".$data['id']."', "
            . "block_type='".$data['block_type']."', "
            . "h1_text='".$data['h1_text']."', "
            . "h2_text='".$data['h2_text']."', "
            . "p_text='".$data['p_text']."', "
            . "note_text='".$data['note_text']."', "
            . "block_status='1', block_order='".$data['block_order']."';");

        $lastid = $this->getLastInsertID();
        if ($_FILES['image_content']['tmp_name']!=='' && $data['block_type'] == 5) {
            $fname = 'banner_'.time().'.jpg';
            $path = 'static/uploads/thumbs/';
            move_uploaded_file($_FILES['image_content']['tmp_name'],$path.$fname);
            $this->execute("UPDATE azonics_prods_blocks SET image_content='".$path.$fname."' WHERE block_id='".$lastid."';");
        }

        return true;
    }

    public function deleteBlock() {
        $block_id = $this->escapeString($_REQUEST['block_id']);
        $this->execute("delete from azonics_prods_blocks where block_id='".$block_id."';");
        return true;
    }

    public function getPrevBlock($block_id) {
        $block_id = $this->escapeString($block_id);
        $row = $this->query("select * from azonics_prods_blocks where block_order < (select block_order from azonics_package_blocks where block_id='".$block_id."') and box_id='".$_REQUEST['id']."' order by block_order desc limit 1;");
        return isset($row[0]) ? $row[0] : null;
    }

    public function getNextBlock($block_id) {
        $block_id = $this->escapeString($block_id);
        $row = $this->query("select * from azonics_prods_blocks where block_order > (select block_order from azonics_package_blocks where block_id='".$block_id."') and box_id='".$_REQUEST['id']."' order by block_order asc limit 1;");
        return isset($row[0]) ? $row[0] : null;
    }

    public function getMaxBlockOrder() {
        $row = $this->query("select max(block_order) as max_order from azonics_prods_blocks where box_id='".$_REQUEST['id']."';");
        return isset($row[0]) ? $row[0]->max_order : 0;
    }

    public function moveBlock($direction) {
        $block_id = $this->escapeString($_REQUEST['block_id']);
        $block = $this->loadBlock($block_id);

        if ($direction == 'up') {
            $prevBlock = $this->getPrevBlock($block_id);
            if ($prevBlock != null) {
                $this->execute("update azonics_prods_blocks set block_order='".$block->block_order."' where block_id='".$prevBlock->block_id."';");
                $this->execute("update azonics_prods_blocks set block_order='".$prevBlock->block_order."' where block_id='".$block_id."';");
            }
        } else if ($direction == 'down') {
            $nextBlock = $this->getNextBlock($block_id);
            if ($nextBlock != null) {
                $this->execute("update azonics_prods_blocks set block_order='".$block->block_order."' where block_id='".$nextBlock->block_id."';");
                $this->execute("update azonics_prods_blocks set block_order='".$nextBlock->block_order."' where block_id='".$block_id."';");
            }
        }
        
        return true;
    }
    
}