PHP Dosya Yöneticisi

<?php

class Roomextra extends CI_Model
{

public function id($id)
    {
        return $this->db
            ->from($this->table)
            ->where('id' , $id)
            ->where('language' , $this->language)
            ->get()
            ->row();
    }

public function all($limit = null, $offset = null)
    {
        $this->utils->filter();

if( $limit != null ){
            $this->db->limit($limit, $offset);
        }

return $this->db
            ->from($this->table)
            ->where('language', $this->language)
            ->order_by('order', 'asc')
            ->order_by('id', 'asc')
            ->get()
            ->result();

}

public function count($all = false)
    {
        $this->utils->filter();

return $this->db
            ->from($this->table)
            ->where('language', $this->language)
            ->count_all_results();
    }

public function insert($data = [])
    {
        $order = 1;
        $lastOrderRecord = $this->db
            ->from($this->table)
            ->where('language', $this->language)
            ->order_by('order', 'desc')
            ->limit(1)
            ->get()
            ->row();

if($lastOrderRecord) {
            $order = $lastOrderRecord->order + 1;
        }

$this->db->insert($this->table, [
            'title' => $this->input->post('title'),
            'order' => $order,
            'image' => $data['image']['name'],
            'language' => $this->language
        ]);

return $this->db->insert_id();

}

public function update($record, $data = [])
    {
        $this->db
            ->where('id', $record->id)
            ->update($this->table, [
                'title' => $this->input->post('title'),
                'image' => $data['image']['name'],
            ]);

return $this->db->affected_rows();

}

public function delete($data)
    {
        if (is_array($data)) {
            $records = $this->db
                ->from($this->table)
                ->where_in('id', $data)
                ->get()
                ->result();

$success = $this->db
                ->where_in('id', $data)
                ->delete($this->table);

return $success;
        }

$success = $this->db
            ->where('id', $data->id)
            ->delete($this->table);

return $success;
    }

public function order($ids = null)
    {
        if (is_array($ids)) {
            $records = $this->db
                ->from($this->table)
                ->where_in('id', $ids)
                ->where_in('language', $this->language)
                ->order_by('order', 'asc')
                ->order_by('id', 'desc')
                ->get()
                ->result();

$firstOrder = 0;
            $affected = 0;

foreach ($records as $record) {
                if ($firstOrder === 0) {
                    $firstOrder = $record->order;
                }

$order = array_search($record->id, $ids) + $firstOrder;

if ($record->order != $order) {
                    $this->db
                        ->where('id', $record->id)
                        ->update($this->table, ['order' => $order]);

if ($this->db->affected_rows() > 0) {
                        $affected++;
                    }
                }

}

return $affected;
        }

}
}

İptal

📁 PHP Dosya Yöneticisi

📝 Roomextra.php

📝 Roomextra.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)