Helper.php 2.6 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374
  1. <?php
  2. if (!function_exists('value_from_rs')) {
  3. function value_from_rs($rs, $field, $checks, $condition = "all") {
  4. $result = '-';
  5. switch ($condition) {
  6. case "all":
  7. foreach ($rs as $record) {
  8. $failed = false;
  9. foreach ($checks as $check) {
  10. if($check[1] === '=') {
  11. if(!($record->{$check[0]} == $check[2])) {
  12. $failed = true;
  13. break;
  14. }
  15. }
  16. else if($check[1] === '!=') {
  17. if(!($record->{$check[0]} != $check[2])) {
  18. $failed = true;
  19. break;
  20. }
  21. }
  22. }
  23. if(!$failed) {
  24. $result = $record->$field;
  25. break;
  26. }
  27. }
  28. break;
  29. case "any":
  30. foreach ($rs as $record) {
  31. foreach ($checks as $check) {
  32. if($check[1] === '=') {
  33. if($record->{$check[0]} == $check[2]) {
  34. $result = $record->$field;
  35. break;
  36. }
  37. }
  38. else if($check[1] === '!=') {
  39. if($record->{$check[0]} != $check[2]) {
  40. $result = $record->$field;
  41. break;
  42. }
  43. }
  44. }
  45. }
  46. break;
  47. case "none":
  48. foreach ($rs as $record) {
  49. $failed = false;
  50. foreach ($checks as $check) {
  51. if($check[1] === '=') {
  52. if($record->{$check[0]} == $check[2]) {
  53. $failed = true;
  54. break;
  55. }
  56. }
  57. else if($check[1] === '!=') {
  58. if($record->{$check[0]} != $check[2]) {
  59. $failed = true;
  60. break;
  61. }
  62. }
  63. }
  64. if(!$failed) {
  65. $result = $record->$field;
  66. break;
  67. }
  68. }
  69. break;
  70. }
  71. return $result;
  72. }
  73. }