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