cm-ggotmaeule-backend/application/models/Social_meta_model.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');

/**
 * Social Meta model class
 */

class Social_meta_model extends MY_Model
{

    /**
     * 테이블명
     */
    public $_table = 'social_meta';

    /**
     * 사용되는 테이블의 프라이머리키
     */
    public $parent_key = 'user_id';

    public $meta_key = 'smt_key';

    public $meta_value = 'smt_value';

    public $cache_prefix= 'social_meta/social-meta-model-get-'; // 캐시 사용시 프리픽스

    public $cache_time = 86400; // 캐시 저장시간

    function __construct()
    {
        parent::__construct();

        check_cache_dir('social_meta');
    }


    public function get_all_meta($user_id = 0)
    {
        if (empty($user_id)) {
            return false;
        }

        $cachename = $this->cache_prefix . $user_id;
        $data = array();
        if ( ! $data = $this->cache->get($cachename)) {
            $result = array();
            $res = $this->get($primary_value = '', $select = '', array($this->parent_key => $user_id));
            if ($res && is_array($res)) {
                foreach ($res as $val) {
                    $result[$val[$this->meta_key]] = $val[$this->meta_value];
                }
            }
            $data['result'] = $result;
            $data['cached'] = '1';
            $this->cache->save($cachename, $data, $this->cache_time);
        }
        return isset($data['result']) ? $data['result'] : false;
    }


    public function save($user_id = 0, $savedata = '')
    {
        if (empty($user_id)) {
            return false;
        }

        if ($savedata && is_array($savedata)) {
            foreach ($savedata as $column => $value) {
                $this->meta_update($user_id, $column, $value);
            }
        }
        $this->cache->delete($this->cache_prefix . $user_id);
    }


    public function deletemeta($user_id = 0)
    {
        if (empty($user_id)) {
            return false;
        }
        $this->delete_where(array($this->parent_key => $user_id));
        $this->cache->delete($this->cache_prefix . $user_id);
    }


    public function meta_update($user_id = 0, $column = '', $value = false)
    {
        if (empty($user_id)) {
            return false;
        }

        $column = trim($column);
        if (empty($column)) {
            return false;
        }

        $old_value = $this->item($user_id, $column);
        if (empty($value)) {
            $value = '';
        }
        if ($value === $old_value) {
            return false;
        }

        if (false === $old_value) {
            return $this->add_meta($user_id, $column, $value);
        }

        return $this->update_meta($user_id, $column, $value);
    }


    public function item($user_id = 0, $column = '')
    {
        if (empty($user_id)) {
            return false;
        }
        if (empty($column)) {
            return false;
        }

        $result = $this->get_all_meta($user_id);

        return isset($result[ $column ]) ? $result[ $column ] : false;
    }


    public function add_meta($user_id = 0, $column = '', $value = '')
    {
        if (empty($user_id)) {
            return false;
        }
        $column = trim($column);
        if (empty($column)) {
            return false;
        }

        $updatedata = array(
            'user_id' => $user_id,
            'smt_key' => $column,
            'smt_value' => $value,
        );
        $this->db->replace($this->_table, $updatedata);

        return true;
    }


    public function update_meta($user_id = 0, $column = '', $value = '')
    {
        if (empty($user_id)) {
            return false;
        }

        $column = trim($column);
        if (empty($column)) {
            return false;
        }

        $this->db->where($this->parent_key, $user_id);
        $this->db->where($this->meta_key, $column);
        $data = array($this->meta_value => $value);
        $this->db->update($this->_table, $data);

        return true;
    }


    public function get_user_id_by_social ($social_type = '', $social_id = '')
    {
        if (empty($social_type)) {
            return false;
        }
        if (empty($social_id)) {
            return false;
        }

        $key = $social_type . '_id';
        $where = array(
            'smt_key' => $key,
            'smt_value' => $social_id
        );
        $info = $this->get_one('', '', $where);

        return isset($info['user_id']) ? $info['user_id'] : false;
    }


    public function get_social_id_by_user_id ($social_type = '', $user_id = 0)
    {
        if (empty($social_type)) {
            return false;
        }
        $user_id = (int) $user_id;
        if (empty($user_id) OR $user_id < 1) {
            return false;
        }

        $key = $social_type . '_id';
        $where = array(
            'smt_key' => $key,
            'user_id' => $user_id
        );
        $info = $this->get_one('', '', $where);

        return isset($info['smt_value']) ? $info['smt_value'] : false;
    }
}