Proyectos de Subversion LeadersLinked - Services

Rev

Ir a la última revisión | | Ultima modificación | Ver Log |

Rev Autor Línea Nro. Línea
324 www 1 
<?php
2 
declare(strict_types=1);
3 
 
4 
namespace LeadersLinked\Mapper;
5 
 
6 
use LeadersLinked\Mapper\Common\MapperCommon;
7 
use Laminas\Db\Adapter\AdapterInterface;
8 
use LeadersLinked\Model\HabitUserLogCategory;
9 
use LeadersLinked\Hydrator\ObjectPropertyHydrator;
10 
use Laminas\Db\Sql\Expression;
11 
 
12 
 
13 
 
14 
class HabitUserLogCategoryMapper extends MapperCommon
15 
{
16 
    const _TABLE = 'tbl_habits_user_logs_categories';
17 
 
18 
    /**
19 
     *
20 
     * @var HabitUserLogCategoryMapper
21 
     */
22 
    private static $_instance;
23 
 
24 
    /**
25 
     *
26 
     * @param AdapterInterface $adapter
27 
     */
28 
    private function __construct($adapter)
29 
    {
30 
        parent::__construct($adapter);
31 
    }
32 
 
33 
    /**
34 
     *
35 
     * @param AdapterInterface $adapter
36 
     * @return HabitUserLogCategoryMapper
37 
     */
38 
    public static function getInstance($adapter)
39 
    {
40 
        if(self::$_instance == null) {
41 
            self::$_instance = new HabitUserLogCategoryMapper($adapter);
42 
        }
43 
        return self::$_instance;
44 
    }
45 
 
46 
 
47 
 
48 
    /**
49 
     *
50 
     * @param int $user_id
51 
     * @param int $category_id
52 
     * @return HabitUserLogCategory
53 
     */
54 
    public function fetchOneByUserIdAndCategoryIdAndDate($user_id, $category_id, $date)
55 
    {
56 
        $prototype = new HabitUserLogCategory();
57 
 
58 
        $select = $this->sql->select(self::_TABLE);
59 
        $select->where->equalTo('user_id', $user_id);
60 
        $select->where->equalTo('category_id', $category_id);
61 
        $select->where->equalTo('date', $date);
62 
 
63 
 
64 
        return $this->executeFetchOneObject($select, $prototype);
65 
    }
66 
 
67 
 
68 
    /**
69 
     *
70 
     * @param HabitUserLogCategory $record
71 
     * return boolean
72 
     */
73 
    public function insert($record)
74 
    {
75 
        $hydrator = new ObjectPropertyHydrator();
76 
        $values = $hydrator->extract($record);
77 
        $values = $this->removeEmpty($values);
78 
 
79 
        $insert = $this->sql->insert(self::_TABLE);
80 
        $insert->values($values);
81 
 
82 
        $result = $this->executeInsert($insert);
83 
        if($result) {
84 
            $record->id = $this->lastInsertId;
85 
        }
86 
        return $result;
87 
    }
88 
 
89 
 
90 
    /**
91 
     *
92 
     * @param HabitUserLogCategory $record
93 
     * return boolean
94 
     */
95 
    public function update($record)
96 
    {
97 
        $hydrator = new ObjectPropertyHydrator();
98 
        $values = $hydrator->extract($record);
99 
        $values = $this->removeEmpty($values);
100 
 
101 
 
102 
        $update = $this->sql->update(self::_TABLE);
103 
        $update->set($values);
104 
        $update->where->equalTo('id', $record->id);
105 
 
106 
        return $this->executeUpdate($update);
107 
    }
108 
 
109 
 
110 
 
111 
 
112 
 
113 
 
114 
 
115 
 
116 
 
117 
 
118 
}