extra_field_value.lib.php 28 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * Declaration for the ExtraFieldValue class, managing the values in extra
  5. * fields for any datatype
  6. * @package chamilo.library
  7. */
  8. /**
  9. * Class managing the values in extra fields for any datatype
  10. * @package chamilo.library.extrafields
  11. */
  12. class ExtraFieldValue extends Model
  13. {
  14. public $type = null;
  15. public $columns = array('id', 'field_id', 'field_value', 'tms', 'comment');
  16. /** @var string session_id, course_code, user_id, question id */
  17. public $handler_id = null;
  18. public $entityName;
  19. /**
  20. * Formats the necessary elements for the given datatype
  21. * @param string The type of data to which this extra field applies (user, course, session, ...)
  22. * @return void (or false if unmanaged datatype)
  23. * @assert (-1) === false
  24. */
  25. public function __construct($type)
  26. {
  27. $this->type = $type;
  28. $extra_field = new ExtraField($this->type);
  29. $this->handler_id = $extra_field->handler_id;
  30. switch ($this->type) {
  31. case 'course':
  32. $this->table = Database::get_main_table(TABLE_MAIN_COURSE_FIELD_VALUES);
  33. $this->table_handler_field = Database::get_main_table(TABLE_MAIN_COURSE_FIELD);
  34. $this->author_id = 'user_id';
  35. $this->entityName = 'ChamiloLMS\Entity\CourseFieldValues';
  36. break;
  37. case 'user':
  38. $this->table = Database::get_main_table(TABLE_MAIN_USER_FIELD_VALUES);
  39. $this->table_handler_field = Database::get_main_table(TABLE_MAIN_USER_FIELD);
  40. $this->author_id = 'author_id';
  41. $this->entityName = 'ChamiloLMS\Entity\UserFieldValues';
  42. break;
  43. case 'session':
  44. $this->table = Database::get_main_table(TABLE_MAIN_SESSION_FIELD_VALUES);
  45. $this->table_handler_field = Database::get_main_table(TABLE_MAIN_SESSION_FIELD);
  46. $this->author_id = 'user_id';
  47. $this->entityName = 'ChamiloLMS\Entity\SessionFieldValues';
  48. break;
  49. case 'question':
  50. $this->table = Database::get_main_table(TABLE_MAIN_QUESTION_FIELD_VALUES);
  51. $this->table_handler_field = Database::get_main_table(TABLE_MAIN_QUESTION_FIELD);
  52. $this->author_id = 'user_id';
  53. $this->entityName = 'ChamiloLMS\Entity\QuestionFieldValues';
  54. break;
  55. case 'lp':
  56. $this->table = Database::get_main_table(TABLE_MAIN_LP_FIELD_VALUES);
  57. $this->table_handler_field = Database::get_main_table(TABLE_MAIN_LP_FIELD);
  58. $this->author_id = 'lp_id';
  59. //$this->entityName = 'ChamiloLMS\Entity\QuestionFieldValues';
  60. break;
  61. default:
  62. //unmanaged datatype, return false to let the caller know it
  63. // didn't work
  64. return false;
  65. }
  66. $this->columns[] = $this->handler_id;
  67. $this->columns[] = $this->author_id;
  68. }
  69. /**
  70. * Gets the number of values stored in the table (all fields together)
  71. * for this type of resource
  72. * @return integer Number of rows in the table
  73. * @assert () !== false
  74. */
  75. public function get_count()
  76. {
  77. $row = Database::select('count(*) as count', $this->table, array(), 'first');
  78. return $row['count'];
  79. }
  80. /**
  81. * Saves a series of records given as parameter into the coresponding table
  82. * @param array Structured parameter for the insertion into the *_field_values table
  83. * @return mixed false on empty params, void otherwise
  84. * @assert (array()) === false
  85. */
  86. public function save_field_values($params)
  87. {
  88. $extra_field = new ExtraField($this->type);
  89. if (empty($params[$this->handler_id])) {
  90. return false;
  91. }
  92. foreach ($params as $key => $value) {
  93. $found = strpos($key, '__persist__');
  94. if ($found) {
  95. $tempKey = str_replace('__persist__', '', $key);
  96. if (!isset($params[$tempKey])) {
  97. $params[$tempKey] = array();
  98. }
  99. }
  100. }
  101. // Parse params.
  102. foreach ($params as $key => $value) {
  103. if (substr($key, 0, 6) == 'extra_') {
  104. // An extra field.
  105. $field_variable = substr($key, 6);
  106. $extra_field_info = $extra_field->get_handler_field_info_by_field_variable($field_variable);
  107. if ($extra_field_info) {
  108. $commentVariable = 'extra_'.$field_variable.'_comment';
  109. $comment = isset($params[$commentVariable]) ? $params[$commentVariable] : null;
  110. switch ($extra_field_info['field_type']) {
  111. case ExtraField::FIELD_TYPE_TAG :
  112. $old = self::getAllValuesByItemAndField(
  113. $params[$this->handler_id],
  114. $extra_field_info['id']
  115. );
  116. $deleteItems = array();
  117. if (!empty($old)) {
  118. $oldIds = array();
  119. foreach ($old as $oldItem) {
  120. $oldIds[] = $oldItem['field_value'];
  121. }
  122. $deleteItems = array_diff($oldIds, $value);
  123. }
  124. foreach ($value as $optionId) {
  125. $new_params = array(
  126. $this->handler_id => $params[$this->handler_id],
  127. 'field_id' => $extra_field_info['id'],
  128. 'field_value' => $optionId,
  129. 'comment' => $comment
  130. );
  131. self::save($new_params);
  132. }
  133. if (!empty($deleteItems)) {
  134. foreach ($deleteItems as $deleteFieldValue) {
  135. self::deleteValuesByHandlerAndFieldAndValue(
  136. $params[$this->handler_id],
  137. $extra_field_info['id'],
  138. $deleteFieldValue
  139. );
  140. }
  141. }
  142. break;
  143. default;
  144. $new_params = array(
  145. $this->handler_id => $params[$this->handler_id],
  146. 'field_id' => $extra_field_info['id'],
  147. 'field_value' => $value,
  148. 'comment' => $comment
  149. );
  150. self::save($new_params);
  151. }
  152. }
  153. }
  154. }
  155. }
  156. /**
  157. * Save values in the *_field_values table
  158. * @param array Structured array with the values to save
  159. * @param boolean Whether to show the insert query (passed to the parent save() method)
  160. * @result mixed The result sent from the parent method
  161. * @assert (array()) === false
  162. */
  163. public function save($params, $show_query = false)
  164. {
  165. $extra_field = new ExtraField($this->type);
  166. // Setting value to insert.
  167. $value = $params['field_value'];
  168. $value_to_insert = null;
  169. if (is_array($value)) {
  170. $value_to_insert = implode(';', $value);
  171. } else {
  172. $value_to_insert = Database::escape_string($value);
  173. }
  174. $params['field_value'] = $value_to_insert;
  175. //If field id exists
  176. $extra_field_info = $extra_field->get($params['field_id']);
  177. if ($extra_field_info) {
  178. switch ($extra_field_info['field_type']) {
  179. case ExtraField::FIELD_TYPE_RADIO:
  180. case ExtraField::FIELD_TYPE_SELECT:
  181. case ExtraField::FIELD_TYPE_SELECT_MULTIPLE:
  182. //$field_options = $session_field_option->get_field_options_by_field($params['field_id']);
  183. //$params['field_value'] = split(';', $value_to_insert);
  184. /*
  185. if ($field_options) {
  186. $check = false;
  187. foreach ($field_options as $option) {
  188. if (in_array($option['option_value'], $values)) {
  189. $check = true;
  190. break;
  191. }
  192. }
  193. if (!$check) {
  194. return false; //option value not found
  195. }
  196. } else {
  197. return false; //enumerated type but no option found
  198. }*/
  199. break;
  200. case ExtraField::FIELD_TYPE_TEXT:
  201. case ExtraField::FIELD_TYPE_TEXTAREA:
  202. break;
  203. case ExtraField::FIELD_TYPE_DOUBLE_SELECT:
  204. if (is_array($value)) {
  205. if (isset($value['extra_'.$extra_field_info['field_variable']]) &&
  206. isset($value['extra_'.$extra_field_info['field_variable'].'_second'])
  207. ) {
  208. $value_to_insert = $value['extra_'.$extra_field_info['field_variable']].'::'.$value['extra_'.$extra_field_info['field_variable'].'_second'];
  209. } else {
  210. $value_to_insert = null;
  211. }
  212. }
  213. break;
  214. default:
  215. break;
  216. }
  217. if ($extra_field_info['field_type'] == ExtraField::FIELD_TYPE_TAG) {
  218. $field_values = self::getAllValuesByItemAndFieldAndValue(
  219. $params[$this->handler_id],
  220. $params['field_id'],
  221. $value
  222. );
  223. } else {
  224. $field_values = self::get_values_by_handler_and_field_id(
  225. $params[$this->handler_id],
  226. $params['field_id']
  227. );
  228. }
  229. $params['field_value'] = $value_to_insert;
  230. $params['tms'] = api_get_utc_datetime();
  231. $params[$this->author_id] = api_get_user_id();
  232. // Insert
  233. if (empty($field_values)) {
  234. if ($extra_field_info['field_loggeable'] == 1) {
  235. global $app;
  236. switch($this->type) {
  237. case 'question':
  238. $extraFieldValue = new ChamiloLMS\Entity\QuestionFieldValues();
  239. $extraFieldValue->setUserId(api_get_user_id());
  240. $extraFieldValue->setQuestionId($params[$this->handler_id]);
  241. break;
  242. case 'course':
  243. $extraFieldValue = new ChamiloLMS\Entity\CourseFieldValues();
  244. $extraFieldValue->setUserId(api_get_user_id());
  245. $extraFieldValue->setQuestionId($params[$this->handler_id]);
  246. break;
  247. case 'user':
  248. $extraFieldValue = new ChamiloLMS\Entity\UserFieldValues();
  249. $extraFieldValue->setUserId($params[$this->handler_id]);
  250. $extraFieldValue->setAuthorId(api_get_user_id());
  251. break;
  252. case 'session':
  253. $extraFieldValue = new ChamiloLMS\Entity\SessionFieldValues();
  254. $extraFieldValue->setUserId(api_get_user_id());
  255. $extraFieldValue->setSessionId($params[$this->handler_id]);
  256. break;
  257. }
  258. if (isset($extraFieldValue)) {
  259. if (!empty($params['field_value'])) {
  260. $extraFieldValue->setComment($params['comment']);
  261. $extraFieldValue->setFieldValue($params['field_value']);
  262. $extraFieldValue->setFieldId($params['field_id']);
  263. $extraFieldValue->setTms(api_get_utc_datetime(null, false, true));
  264. $app['orm.ems']['db_write']->persist($extraFieldValue);
  265. $app['orm.ems']['db_write']->flush();
  266. }
  267. }
  268. } else {
  269. if ($extra_field_info['field_type'] == ExtraField::FIELD_TYPE_TAG) {
  270. $option = new ExtraFieldOption($this->type);
  271. $optionExists = $option->get($params['field_value']);
  272. if (empty($optionExists)) {
  273. $optionParams = array(
  274. 'field_id' => $params['field_id'],
  275. 'option_value' => $params['field_value']
  276. );
  277. $optionId = $option->saveOptions($optionParams);
  278. } else {
  279. $optionId = $optionExists['id'];
  280. }
  281. $params['field_value'] = $optionId;
  282. if ($optionId) {
  283. return parent::save($params, $show_query);
  284. }
  285. } else {
  286. return parent::save($params, $show_query);
  287. }
  288. }
  289. } else {
  290. // Update
  291. if ($extra_field_info['field_loggeable'] == 1) {
  292. global $app;
  293. switch($this->type) {
  294. case 'question':
  295. $extraFieldValue = $app['orm.ems']['db_write']->getRepository('ChamiloLMS\Entity\QuestionFieldValues')->find($field_values['id']);
  296. $extraFieldValue->setUserId(api_get_user_id());
  297. $extraFieldValue->setQuestionId($params[$this->handler_id]);
  298. break;
  299. case 'course':
  300. $extraFieldValue = $app['orm.ems']['db_write']->getRepository('ChamiloLMS\Entity\CourseFieldValues')->find($field_values['id']);
  301. $extraFieldValue->setUserId(api_get_user_id());
  302. $extraFieldValue->setCourseCode($params[$this->handler_id]);
  303. break;
  304. case 'user':
  305. $extraFieldValue = $app['orm.ems']['db_write']->getRepository('ChamiloLMS\Entity\UserFieldValues')->find($field_values['id']);
  306. $extraFieldValue->setUserId(api_get_user_id());
  307. $extraFieldValue->setAuthorId(api_get_user_id());
  308. break;
  309. case 'session':
  310. $extraFieldValue = $app['orm.ems']['db_write']->getRepository('ChamiloLMS\Entity\SessionFieldValues')->find($field_values['id']);
  311. $extraFieldValue->setUserId(api_get_user_id());
  312. $extraFieldValue->setSessionId($params[$this->handler_id]);
  313. break;
  314. }
  315. if (isset($extraFieldValue)) {
  316. if (!empty($params['field_value'])) {
  317. /*
  318. * If the field value is similar to the previous value then the comment will be the same
  319. in order to no save in the log an empty record
  320. */
  321. if ($extraFieldValue->getFieldValue() == $params['field_value']) {
  322. if (empty($params['comment'])) {
  323. $params['comment'] = $extraFieldValue->getComment();
  324. }
  325. }
  326. $extraFieldValue->setComment($params['comment']);
  327. $extraFieldValue->setFieldValue($params['field_value']);
  328. $extraFieldValue->setFieldId($params['field_id']);
  329. $extraFieldValue->setTms(api_get_utc_datetime(null, false, true));
  330. $app['orm.ems']['db_write']->persist($extraFieldValue);
  331. $app['orm.ems']['db_write']->flush();
  332. }
  333. }
  334. } else {
  335. $params['id'] = $field_values['id'];
  336. return parent::update($params, $show_query);
  337. }
  338. }
  339. }
  340. }
  341. /**
  342. * Returns the value of the given extra field on the given resource
  343. * @param int Item ID (It could be a session_id, course_id or user_id)
  344. * @param int Field ID (the ID from the *_field table)
  345. * @param bool Whether to transform the result to a human readable strings
  346. * @return mixed A structured array with the field_id and field_value, or false on error
  347. * @assert (-1,-1) === false
  348. */
  349. public function get_values_by_handler_and_field_id($item_id, $field_id, $transform = false)
  350. {
  351. $field_id = intval($field_id);
  352. $item_id = Database::escape_string($item_id);
  353. $sql = "SELECT s.*, field_type FROM {$this->table} s
  354. INNER JOIN {$this->table_handler_field} sf ON (s.field_id = sf.id)
  355. WHERE {$this->handler_id} = '$item_id' AND
  356. field_id = '".$field_id."'
  357. ORDER BY id";
  358. $result = Database::query($sql);
  359. if (Database::num_rows($result)) {
  360. $result = Database::fetch_array($result, 'ASSOC');
  361. if ($transform) {
  362. if (!empty($result['field_value'])) {
  363. switch ($result['field_type']) {
  364. case ExtraField::FIELD_TYPE_DOUBLE_SELECT:
  365. $field_option = new ExtraFieldOption($this->type);
  366. $options = explode('::', $result['field_value']);
  367. // only available for PHP 5.4 :( $result['field_value'] = $field_option->get($options[0])['id'].' -> ';
  368. $result = $field_option->get($options[0]);
  369. $result_second = $field_option->get($options[1]);
  370. if (!empty($result)) {
  371. $result['field_value'] = $result['option_display_text'].' -> ';
  372. $result['field_value'] .= $result_second['option_display_text'];
  373. }
  374. break;
  375. case ExtraField::FIELD_TYPE_SELECT:
  376. $field_option = new ExtraFieldOption($this->type);
  377. $extra_field_option_result = $field_option->get_field_option_by_field_and_option(
  378. $result['field_id'],
  379. $result['field_value']
  380. );
  381. if (isset($extra_field_option_result[0])) {
  382. $result['field_value'] = $extra_field_option_result[0]['option_display_text'];
  383. }
  384. break;
  385. }
  386. }
  387. }
  388. return $result;
  389. } else {
  390. return false;
  391. }
  392. }
  393. /**
  394. * @param string $tag
  395. * @param int $field_id
  396. * @param int $limit
  397. * @return array
  398. */
  399. public function searchValuesByField($tag, $field_id, $limit = 10)
  400. {
  401. $field_id = intval($field_id);
  402. $limit = intval($limit);
  403. $tag = Database::escape_string($tag);
  404. $sql = "SELECT DISTINCT s.field_value, s.field_id
  405. FROM {$this->table} s
  406. INNER JOIN {$this->table_handler_field} sf ON (s.field_id = sf.id)
  407. WHERE
  408. field_id = '".$field_id."' AND
  409. field_value LIKE '%$tag%'
  410. ORDER BY field_value
  411. LIMIT 0, $limit
  412. ";
  413. $result = Database::query($sql);
  414. $values = array();
  415. if (Database::num_rows($result)) {
  416. $values = Database::store_result($result, 'ASSOC');
  417. }
  418. return $values;
  419. }
  420. /**
  421. * Gets a structured array of the original item and its extra values, using
  422. * a specific original item and a field name (like "branch", or "birthdate")
  423. * @param int Item ID from the original table
  424. * @param string The name of the field we are looking for
  425. * @return mixed Array of results, or false on error or not found
  426. * @assert (-1,'') === false
  427. */
  428. public function get_values_by_handler_and_field_variable($item_id, $field_variable, $transform = false)
  429. {
  430. $item_id = Database::escape_string($item_id);
  431. $field_variable = Database::escape_string($field_variable);
  432. $sql = "SELECT s.*, field_type FROM {$this->table} s
  433. INNER JOIN {$this->table_handler_field} sf
  434. ON (s.field_id = sf.id)
  435. WHERE
  436. {$this->handler_id} = '$item_id' AND
  437. field_variable = '".$field_variable."'
  438. ORDER BY id";
  439. $result = Database::query($sql);
  440. if (Database::num_rows($result)) {
  441. $result = Database::fetch_array($result, 'ASSOC');
  442. if ($transform) {
  443. if ($result['field_type'] == ExtraField::FIELD_TYPE_DOUBLE_SELECT) {
  444. if (!empty($result['field_value'])) {
  445. $field_option = new ExtraFieldOption($this->type);
  446. $options = explode('::', $result['field_value']);
  447. // only available for PHP 5.4 :( $result['field_value'] = $field_option->get($options[0])['id'].' -> ';
  448. $result = $field_option->get($options[0]);
  449. $result_second = $field_option->get($options[1]);
  450. if (!empty($result)) {
  451. $result['field_value'] = $result['option_display_text'].' -> ';
  452. $result['field_value'] .= $result_second['option_display_text'];
  453. }
  454. }
  455. }
  456. }
  457. return $result;
  458. } else {
  459. return false;
  460. }
  461. }
  462. /**
  463. * Gets the ID from the item (course, session, etc) for which
  464. * the given field is defined with the given value
  465. * @param string Field (type of data) we want to check
  466. * @param string Data we are looking for in the given field
  467. * @param bool Whether to transform the result to a human readable strings
  468. * @param bool Whether to return the last element or simply the first one we get
  469. * @return mixed Give the ID if found, or false on failure or not found
  470. * @assert (-1,-1) === false
  471. */
  472. public function get_item_id_from_field_variable_and_field_value($field_variable, $field_value, $transform = false, $last = false)
  473. {
  474. $field_value = Database::escape_string($field_value);
  475. $field_variable = Database::escape_string($field_variable);
  476. $sql = "SELECT {$this->handler_id} FROM {$this->table} s
  477. INNER JOIN {$this->table_handler_field} sf
  478. ON (s.field_id = sf.id)
  479. WHERE
  480. field_value = '$field_value' AND
  481. field_variable = '".$field_variable."'
  482. ORDER BY {$this->handler_id}
  483. ";
  484. if ($last) {
  485. // If we want the last element instead of the first
  486. // This is useful in special cases where there might
  487. // (erroneously) be more than one row for an item
  488. $sql .= ' DESC';
  489. }
  490. $result = Database::query($sql);
  491. if ($result !== false && Database::num_rows($result)) {
  492. $result = Database::fetch_array($result, 'ASSOC');
  493. return $result;
  494. } else {
  495. return false;
  496. }
  497. }
  498. /**
  499. * Get all values for a specific field id
  500. * @param int Field ID
  501. * @return mixed Array of values on success, false on failure or not found
  502. * @assert (-1) === false
  503. */
  504. public function get_values_by_field_id($field_id)
  505. {
  506. $field_id = intval($field_id);
  507. $sql = "SELECT s.*, field_type FROM {$this->table} s
  508. INNER JOIN {$this->table_handler_field} sf
  509. ON (s.field_id = sf.id)
  510. WHERE field_id = '".$field_id."' ORDER BY id";
  511. $result = Database::query($sql);
  512. if (Database::num_rows($result)) {
  513. return Database::store_result($result, 'ASSOC');
  514. }
  515. return false;
  516. }
  517. /**
  518. * @param int $itemId
  519. * @param int $fieldId
  520. * @return array
  521. */
  522. public function getAllValuesByItemAndField($itemId, $fieldId)
  523. {
  524. $fieldId = intval($fieldId);
  525. $itemId = intval($itemId);
  526. $sql = "SELECT s.* FROM {$this->table} s
  527. INNER JOIN {$this->table_handler_field} sf
  528. ON (s.field_id = sf.id)
  529. WHERE
  530. field_id = '".$fieldId."' AND
  531. {$this->handler_id} = '$itemId'
  532. ORDER BY field_value";
  533. $result = Database::query($sql);
  534. if (Database::num_rows($result)) {
  535. return Database::store_result($result, 'ASSOC');
  536. }
  537. return false;
  538. }
  539. /**
  540. * @param int $itemId
  541. * @param int $fieldId
  542. * @param string $fieldValue
  543. * @return array|bool
  544. */
  545. public function getAllValuesByItemAndFieldAndValue($itemId, $fieldId, $fieldValue)
  546. {
  547. $fieldId = intval($fieldId);
  548. $itemId = intval($itemId);
  549. $fieldValue = Database::escape_string($fieldValue);
  550. $sql = "SELECT s.* FROM {$this->table} s
  551. INNER JOIN {$this->table_handler_field} sf
  552. ON (s.field_id = sf.id)
  553. WHERE
  554. field_id = '".$fieldId."' AND
  555. {$this->handler_id} = '$itemId' AND
  556. field_value = $fieldValue
  557. ORDER BY field_value";
  558. $result = Database::query($sql);
  559. if (Database::num_rows($result)) {
  560. return Database::store_result($result, 'ASSOC');
  561. }
  562. return false;
  563. }
  564. /**
  565. * Deletes all the values related to a specific field ID
  566. * @param int Field ID
  567. * @return void
  568. * @assert ('a') == null
  569. */
  570. public function delete_all_values_by_field_id($field_id)
  571. {
  572. $field_id = intval($field_id);
  573. $sql = "DELETE FROM {$this->table} WHERE field_id = $field_id";
  574. Database::query($sql);
  575. }
  576. /**
  577. * Deletes values of a specific field for a specific item
  578. * @param int Item ID (session id, course id, etc)
  579. * @param int Field ID
  580. * @return void
  581. * @assert (-1,-1) == null
  582. */
  583. public function delete_values_by_handler_and_field_id($item_id, $field_id)
  584. {
  585. $field_id = intval($field_id);
  586. $item_id = Database::escape_string($item_id);
  587. $sql = "DELETE FROM {$this->table} WHERE {$this->handler_id} = '$item_id' AND field_id = '".$field_id."' ";
  588. Database::query($sql);
  589. }
  590. /**
  591. * @param int $itemId
  592. * @param int $fieldId
  593. * @param int $fieldValue
  594. */
  595. public function deleteValuesByHandlerAndFieldAndValue($itemId, $fieldId, $fieldValue)
  596. {
  597. $itemId = intval($itemId);
  598. $fieldId = intval($fieldId);
  599. $fieldValue = Database::escape_string($fieldValue);
  600. $sql = "DELETE FROM {$this->table}
  601. WHERE
  602. {$this->handler_id} = '$itemId' AND
  603. field_id = '".$fieldId."' AND
  604. field_value = '$fieldValue'";
  605. Database::query($sql);
  606. }
  607. /**
  608. * Not yet implemented - Compares the field values of two items
  609. * @param int Item 1
  610. * @param int Item 2
  611. * @return mixed Differential array generated from the comparison
  612. */
  613. public function compare_item_values($item_id, $item_to_compare)
  614. {
  615. }
  616. }