Subversion-Projekte lars-tiefland.ci

Revision

Revision 68 | Revision 2242 | Zur aktuellen Revision | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 68 Revision 2049
Zeile 4... Zeile 4...
4
 *
4
 *
5
 * An open source application development framework for PHP
5
 * An open source application development framework for PHP
6
 *
6
 *
7
 * This content is released under the MIT License (MIT)
7
 * This content is released under the MIT License (MIT)
8
 *
8
 *
9
 * Copyright (c) 2014 - 2016, British Columbia Institute of Technology
9
 * Copyright (c) 2014 - 2017, British Columbia Institute of Technology
10
 *
10
 *
11
 * Permission is hereby granted, free of charge, to any person obtaining a copy
11
 * Permission is hereby granted, free of charge, to any person obtaining a copy
12
 * of this software and associated documentation files (the "Software"), to deal
12
 * of this software and associated documentation files (the "Software"), to deal
13
 * in the Software without restriction, including without limitation the rights
13
 * in the Software without restriction, including without limitation the rights
14
 * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
14
 * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
Zeile 27... Zeile 27...
27
 * THE SOFTWARE.
27
 * THE SOFTWARE.
28
 *
28
 *
29
 * @package	CodeIgniter
29
 * @package	CodeIgniter
30
 * @author	EllisLab Dev Team
30
 * @author	EllisLab Dev Team
31
 * @copyright	Copyright (c) 2008 - 2014, EllisLab, Inc. (https://ellislab.com/)
31
 * @copyright	Copyright (c) 2008 - 2014, EllisLab, Inc. (https://ellislab.com/)
32
 * @copyright	Copyright (c) 2014 - 2016, British Columbia Institute of Technology (http://bcit.ca/)
32
 * @copyright	Copyright (c) 2014 - 2017, British Columbia Institute of Technology (http://bcit.ca/)
33
 * @license	http://opensource.org/licenses/MIT	MIT License
33
 * @license	http://opensource.org/licenses/MIT	MIT License
34
 * @link	https://codeigniter.com
34
 * @link	https://codeigniter.com
35
 * @since	Version 3.0.0
35
 * @since	Version 3.0.0
36
 * @filesource
36
 * @filesource
37
 */
37
 */
Zeile 169... Zeile 169...
169
	}
169
	}
Zeile 170... Zeile 170...
170
 
170
 
Zeile 171... Zeile 171...
171
	// --------------------------------------------------------------------
171
	// --------------------------------------------------------------------
172
 
-
 
173
	/**
-
 
174
	 * Update_Batch statement
-
 
175
	 *
-
 
176
	 * Generates a platform-specific batch update string from the supplied data
-
 
177
	 *
-
 
178
	 * @param	string	$table	Table name
-
 
179
	 * @param	array	$values	Update data
-
 
180
	 * @param	string	$index	WHERE key
-
 
181
	 * @return	string
-
 
182
	 */
-
 
183
	protected function _update_batch($table, $values, $index)
-
 
184
	{
-
 
185
		$ids = array();
-
 
186
		foreach ($values as $key => $val)
-
 
187
		{
-
 
188
			$ids[] = $val[$index];
-
 
189
 
-
 
190
			foreach (array_keys($val) as $field)
-
 
191
			{
-
 
192
				if ($field !== $index)
-
 
193
				{
-
 
194
					$final[$field][] = 'WHEN '.$index.' = '.$val[$index].' THEN '.$val[$field];
-
 
195
				}
-
 
196
			}
-
 
197
		}
-
 
198
 
-
 
199
		$cases = '';
-
 
200
		foreach ($final as $k => $v)
-
 
201
		{
-
 
202
			$cases .= $k." = CASE \n"
-
 
203
				.implode("\n", $v)."\n"
-
 
204
				.'ELSE '.$k.' END), ';
-
 
205
		}
-
 
206
 
-
 
207
		$this->where($index.' IN('.implode(',', $ids).')', NULL, FALSE);
-
 
208
 
-
 
209
		return 'UPDATE '.$table.' SET '.substr($cases, 0, -2).$this->_compile_wh('qb_where');
-
 
210
	}
-
 
211
 
-
 
212
	// --------------------------------------------------------------------
-
 
213
 
172
 
214
	/**
173
	/**
215
	 * Truncate statement
174
	 * Truncate statement
216
	 *
175
	 *
217
	 * Generates a platform-specific truncate string from the supplied data
176
	 * Generates a platform-specific truncate string from the supplied data