155. public function __construct(array $config = [])
156. {
157. $this->defaultConfig = Config::default('ZN\Database\DatabaseDefaultConfiguration')
158. ::get('Database', 'database');
159. $this->config = array_merge($this->defaultConfig, $config);
160. $this->db = $this->runDriver();
161. $this->prefix = $this->config['prefix'];
162. Properties::$prefix = $this->prefix;
163.
164. $this->db->connect($this->config);
165. }
166.
167. /**
168. * Magic Debug Info
169. */
170. public function __debugInfo()
171. {
172. return ['return' => $this->stringQuery ?: 'This is a general object, please call the sub method!'];
173. }
174.
1338. */
1339. public function query(string $query, array $secure = [])
1340. {
1341. $secure = $this->secure ?: $secure; $this->secure = [];
1342. $caching = $this->caching; $this->caching = [];
1343. $tableName = $this->tableName; $this->tableName = '';
1344. $jsonDecode = $this->jsonDecode; $this->jsonDecode = [];
1345. $paging = $this->paging ?? 'row'; $this->paging = NULL;
1346.
1347. return (new self($this->config))->setQueryByDriver($query, $secure,
1348. [
1349. 'caching' => $caching,
1350. 'tableName' => $tableName,
1351. 'jsonDecode' => $jsonDecode,
1352. 'paging' => $paging
1353. ]);
1354. }
1355.
1356. /**
1357. * Exec Basic Query
792. }
793.
794. if( $this->transaction === true )
795. {
796. $this->transactionQueries[] = $finalQuery;
797.
798. return $this;
799. }
800.
801. return $this->$returnQuery($finalQuery, $this->secure);
802. }
803.
804. /**
805. * Duplicate Check
806. *
807. * @param string ...$args
808. *
809. * @return DB
810. */
811. public function duplicateCheck(...$args) : DB
205. {
206. $result = 'value';
207.
208. $this->select($select);
209.
210. $whereClause = true;
211. }
212. }
213.
214. $return = $this->get($method);
215.
216. # Return ->get()
217. if( ! isset($result) )
218. {
219. return $return;
220. }
221.
222. # Return ->row(0) || result('object')
223. return $return->$result($whereClause);
224. }
84. return $this->callWhereHavingTalkingQuery($split, $parameters);
85. }
86. # Insert - Update - Delete
87. elseif( in_array($split[1] ?? NULL, ['Delete', 'Update', 'Insert']) )
88. {
89. return $this->callCrudTalkingQuery($split, $parameters);
90. }
91. else
92. {
93. return $this->callResultMethodsTalkingQuery($originMethodName, $split, $parameters);
94. }
95. }
96.
97. /**
98. * Protected call join talkin query
99. */
100. protected function callJoinTalkingQuery($split, $parameters)
101. {
102. $type = $split[0] ?? 'left';
103. $table1 = $split[2] ?? '';
21.
22. // Get Category Single
23. public function getByID($id = null)
24. {
25. return DB::where('catID', $id)->category()->row();
26. }
27.
28. // Anakategori Çekme
29. public function getMainCategories(){
30. return DB::orderBy('sira', 'asc')->where('parent_id', 0)->where('status', 1)->category()->result();
31. }
32.
33. // Anasayfa
34. public function getHomeCategory(){
35. return DB::orderBy('sira', 'asc')->where('parent_id', 0)->where('anasayfa', 1)->where('status', 1)->category()->result();
36. }
37.
38. // Alt Categoriler
39. public function getSubCategories($id = null)
40. {
41. * protected use class name
42. *
43. * @param string $method
44. * @param array $parameters
45. *
46. * @return mixed
47. */
48. protected static function useClassName($method, $parameters)
49. {
50. return Singleton::class(INTERNAL_ACCESS . static::getClassName())->$method(...$parameters);
51. }
52. }
15. * Magic call static
16. *
17. * @param string $method
18. * @param array $parameters
19. *
20. * @return mixed
21. */
22. public static function __callStatic($method, $parameters)
23. {
24. return self::useClassName($method, $parameters);
25. }
26.
27. /**
28. * Magic call
29. *
30. * @param string $method
31. * @param array $parameters
32. *
33. * @return mixed
34. */
77. <ul id="pq-main-menu" class="navbar-nav ml-auto">
78. <li class="menu-item {[ echo CURRENT_CONTROLLER == 'Home' ? 'current-menu-item' : ''; ]}"><a href="{[ echo URL::site() ]}">{[ echo ML::select('home_url_name') ]}a>
79. li>
80. <li class="menu-item {[ echo CURRENT_CONTROLLER == 'Kurumsal' ? 'current-menu-item' : ''; ]}"><a href="{[ echo URL::site(ML::select('kurumsal_url')) ]}">{[ echo ML::select('kurumsal_url_name') ]}a>
81. li>
82. <li class="menu-item {[ echo CURRENT_CONTROLLER == 'Urunler' ? 'current-menu-item' : ''; ]} "><a href="{[ echo URL::site(ML::select('urunler_url')) ]}">{[ echo ML::select('urunler_url_name'); ]}a>
83. <i class="ion-chevron-down pq-submenu-icon">i>
84. {[ if(count(CategoryModel::getMainCategories()) > 0) :]}
85. <ul class="sub-menu">
86. {[ foreach (CategoryModel::getMainCategories() as $cat) {
87.
88. $slug = "slug_tr";
89. $name = "catName_".Lang::get();
90. if(Lang::get() != "tr"){
91. $slug = "slug_en";
92. }
93.
94. ]}
95. <li class="menu-item"><a href="{[ echo URL::site('category/').$cat->$slug ]}">{[ echo $cat->$name; ]}a>li>
96. {[ } ]}
1. {[ Import::view('Sections/header') ]}
2. {[ if (isset($page)) {
3. Import::view($page);
4. }]}
5.
6. {[ Import::view('Sections/footer') ]}
192.
193. echo $header;
194.
195. $randomPageVariable = $head['bodyPage'] ?? $masterPageSet['bodyPage'];
196.
197. if( ! empty($randomPageVariable) )
198. {
199. $randomDataVariable['view'] = $bodyContent;
200.
201. View::use($randomPageVariable, $randomDataVariable, false, $viewDirectory);
202. }
203. else
204. {
205. echo $bodyContent; // @codeCoverageIgnore
206. }
207.
208. $randomFooterVariable = EOL.'