/private/syncObjectGet.php

https://github.com/ciniki/core · PHP · 252 lines · 194 code · 19 blank · 39 comment · 78 complexity · 767d60fb6c4a306007ead908a7f14303 MD5 · raw file 

    

  1. <?php
    2. 

  2. //
    3. 

  3. // Description
    4. 

  4. // -----------
    5. 

  5. //
    6. 

  6. // Arguments
    7. 

  7. // ---------
    8. 

  8. //
    9. 

  9. // Returns
    10. 

  10. // -------
    11. 

  11. //
    12. 

  12. function ciniki_core_syncObjectGet($ciniki, &$sync, $tnid, $o, $args) {
    13. 

  13.     //
    14. 

  14.     // Check for custom get function
    15. 

  15.     //
    16. 

  16. //  error_log("SYNC-INFO: [$tnid] Get " . $o['oname'] . "(" . serialize($args) . ")");
    17. 

  17.     ciniki_core_syncLog($ciniki, 4, "Get " . $o['oname'] . "(" . serialize($args) . ")", null);
    18. 

  18.     if( isset($o['get']) && $o['get'] != '' ) {
    19. 

  19.         ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'syncObjectFunction');
    20. 

  20.         return ciniki_core_syncObjectFunction($ciniki, $sync, $tnid, $o['get'], $args);
    21. 

  21.     }
    22. 

  22. 

  23.     if( isset($o['type']) && $o['type'] == 'settings' ) {
    24. 

  24.         ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'syncSettingGet');
    25. 

  25.         return ciniki_core_syncSettingGet($ciniki, $sync, $tnid, $o, $args);
    26. 

  26.     }
    27. 

  27. 

  28.     //
    29. 

  29.     // Check the args
    30. 

  30.     //
    31. 

  31.     if( (!isset($args['uuid']) || $args['uuid'] == '') 
    32. 

  32.         && (!isset($args['id']) || $args['id'] == '') ) {
    33. 

  33.         return array('stat'=>'fail', 'err'=>array('code'=>'ciniki.core.231', 'msg'=>'No customer specified'));
    34. 

  34.     }
    35. 

  35. 

  36.     ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbQuote');
    37. 

  37.     ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryIDTree');
    38. 

  38. 

  39.     //
    40. 

  40.     // Build the SQL string to get the object details along with history information
    41. 

  41.     //
    42. 

  42.     $table = $o['table'];
    43. 

  43.     $strsql = "SELECT $table.id, $table.uuid AS object_uuid, ";
    44. 

  44.     foreach($o['fields'] as $fid => $finfo) {
    45. 

  45.         $strsql .= "$table.$fid, ";
    46. 

  46.     }
    47. 

  47.     $strsql .= "UNIX_TIMESTAMP($table.date_added) AS date_added, "
    48. 

  48.         . "UNIX_TIMESTAMP($table.last_updated) AS last_updated, ";
    49. 

  49. 

  50.     $history_table = $o['history_table'];
    51. 

  51.     $strsql .= "$history_table.id AS history_id, "
    52. 

  52.         . "$history_table.uuid AS history_uuid, "
    53. 

  53.         . "ciniki_users.uuid AS user_uuid, "
    54. 

  54.         . "$history_table.session, "
    55. 

  55.         . "$history_table.action, "
    56. 

  56.         . "$history_table.table_field, "
    57. 

  57.         . "$history_table.new_value, "
    58. 

  58.         . "UNIX_TIMESTAMP($history_table.log_date) AS log_date ";
    59. 

  59. 

  60.     $strsql .= "FROM $table "
    61. 

  61.         . "LEFT JOIN $history_table ON ($table.id = $history_table.table_key "
    62. 

  62.             . "AND $history_table.tnid = '" . ciniki_core_dbQuote($ciniki, $tnid) . "' "
    63. 

  63.             . "AND $history_table.table_name = '$table' "
    64. 

  64.             . ") "
    65. 

  65.         . "LEFT JOIN ciniki_users ON ($history_table.user_id = ciniki_users.id) ";
    66. 

  66. 

  67.     $strsql .= "WHERE $table.tnid = '" . ciniki_core_dbQuote($ciniki, $tnid) . "' ";
    68. 

  68.     if( isset($args['uuid']) && $args['uuid'] != '' ) {
    69. 

  69.         $strsql .= "AND $table.uuid = '" . ciniki_core_dbQuote($ciniki, $args['uuid']) . "' ";
    70. 

  70.     } elseif( isset($args['id']) && $args['id'] != '' ) {
    71. 

  71.         $strsql .= "AND $table.id = '" . ciniki_core_dbQuote($ciniki, $args['id']) . "' ";
    72. 

  72.     } else {
    73. 

  73.         return array('stat'=>'fail', 'err'=>array('code'=>'ciniki.core.232', 'msg'=>'No ' . $o['name'] . ' specified'));
    74. 

  74.     }
    75. 

  75.     $strsql .= "ORDER BY log_date ";
    76. 

  76. 

  77.     $fields = array_keys($o['fields']);
    78. 

  78.     $fields['uuid'] = 'object_uuid';
    79. 

  79.     $fields['id'] = 'id';
    80. 

  80.     $fields['date_added'] = 'date_added';
    81. 

  81.     $fields['last_updated'] = 'last_updated';
    82. 

  82. 

  83.     $rc = ciniki_core_dbHashQueryIDTree($ciniki, $strsql, $o['pmod'], array(
    84. 

  84.         array('container'=>'objects', 'fname'=>'object_uuid', 
    85. 

  85.             'fields'=>$fields),
    86. 

  86.         array('container'=>'history', 'fname'=>'history_uuid', 
    87. 

  87.             'fields'=>array('user'=>'user_uuid', 'session', 
    88. 

  88.                 'action', 'table_field', 'new_value', 'log_date')),
    89. 

  89.         ));
    90. 

  90.     if( $rc['stat'] != 'ok' ) {
    91. 

  91.         return array('stat'=>'fail', 'err'=>array('code'=>'ciniki.core.233', 'msg'=>'Error retrieving the ' . $o['name'] . ' information', 'err'=>$rc['err']));
    92. 

  92.     }
    93. 

  93. 

  94.     //
    95. 

  95.     // Check that one and only one row was returned
    96. 

  96.     //
    97. 

  97.     if( !isset($rc['objects']) ) {
    98. 

  98.         return array('stat'=>'noexist', 'err'=>array('code'=>'ciniki.core.234', 'msg'=>$o['name'] . ' does not exist'));
    99. 

  99.     }
    100. 

  100.     if( count($rc['objects']) > 1 ) {
    101. 

  101.         return array('stat'=>'fail', 'err'=>array('code'=>'ciniki.core.235', 'msg'=>$o['name'] . ' does not exist'));
    102. 

  102.     }
    103. 

  103.     $object = array_pop($rc['objects']);
    104. 

  104. 

  105.     if( !isset($object['history']) ) {
    106. 

  106.         $object['history'] = array();
    107. 

  107.     }
    108. 

  108. 

  109.     if( !isset($args['translate']) || $args['translate'] == 'yes' ) {
    110. 

  110.         //
    111. 

  111.         // Translate the table_key
    112. 

  112.         //
    113. 

  113.         if( isset($o['fields']) ) {
    114. 

  114.             foreach($o['fields'] as $fid => $finfo) {
    115. 

  115.                 if( isset($finfo['oref']) && $finfo['oref'] != '' 
    116. 

  116.                     && isset($object[$finfo['oref']]) && $object[$finfo['oref']] != '' && $object[$finfo['oref']] != '0' )  {
    117. 

  117.                     // oref is the name of the field that contains the object name referenced eg: ciniki.artcatalog.item
    118. 

  118.                     $object_name = $object[$finfo['oref']];
    119. 

  119.                     ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'syncObjectLoad');
    120. 

  120.                     $rc = ciniki_core_syncObjectLoad($ciniki, $sync, $tnid, $object[$finfo['oref']], array());
    121. 

  121.                     if( $rc['stat'] != 'ok' ) {
    122. 

  122.                         return array('stat'=>'fail', 'err'=>array('code'=>'ciniki.core.236', 'msg'=>'Unable to load object ' . $finfo['oref']));
    123. 

  123.                     }
    124. 

  124.                     $ref_o = $rc['object'];
    125. 

  125.                     //
    126. 

  126.                     // Only lookup if not a setting type.  The settings are treated like a uuid don't need translation
    127. 

  127.                     //
    128. 

  128.                     if( !isset($ref_o['type']) || $ref_o['type'] != 'settings' ) {
    129. 

  129.                         ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'syncObjectLookup');
    130. 

  130.                         $rc = ciniki_core_syncObjectLookup($ciniki, $sync, $tnid, $ref_o, 
    131. 

  131.                             array('local_id'=>$object[$fid]));
    132. 

  132.                         if( $rc['stat'] != 'ok' ) {
    133. 

  133.                             return array('stat'=>'fail', 'err'=>array('code'=>'ciniki.core.237', 'msg'=>'Unable to find reference for ' . $object_name . '(' . $object[$fid] . ')'));
    134. 

  134.                         }
    135. 

  135.                         $object[$fid] = $rc['uuid'];
    136. 

  136.                     }
    137. 

  137.                 }
    138. 

  138.                 elseif( isset($finfo['ref']) && $finfo['ref'] != '' && $object[$fid] != '0' ) {
    139. 

  139.                     ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'syncObjectLoad');
    140. 

  140.                     $rc = ciniki_core_syncObjectLoad($ciniki, $sync, $tnid, $finfo['ref'], array());
    141. 

  141.                     if( $rc['stat'] != 'ok' ) {
    142. 

  142.                         return array('stat'=>'fail', 'err'=>array('code'=>'ciniki.core.238', 'msg'=>'Unable to load object ' . $finfo['ref']));
    143. 

  143.                     }
    144. 

  144.                     $ref_o = $rc['object'];
    145. 

  145.                     ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'syncObjectLookup');
    146. 

  146.                     $rc = ciniki_core_syncObjectLookup($ciniki, $sync, $tnid, $ref_o, 
    147. 

  147.                         array('local_id'=>$object[$fid]));
    148. 

  148.                     if( $rc['stat'] != 'ok' ) {
    149. 

  149.                         return array('stat'=>'fail', 'err'=>array('code'=>'ciniki.core.239', 'msg'=>'Unable to find reference for ' . $ref_o['name'] . '(' . $object[$fid] . ')'));
    150. 

  150.                     }
    151. 

  151.                     $object[$fid] = $rc['uuid'];
    152. 

  152.                 }
    153. 

  153.             }
    154. 

  154.         }
    155. 

  155. 

  156.         //
    157. 

  157.         // Translate the new_value if required
    158. 

  158.         //
    159. 

  159.         foreach($object['history'] as $uuid => $history) {
    160. 

  160.             if( isset($o['fields'][$history['table_field']]) && isset($o['fields'][$history['table_field']]['oref']) && $history['new_value'] != '0' 
    161. 

  161.                 && isset($object[$o['fields'][$history['table_field']]['oref']]) && $object[$o['fields'][$history['table_field']]['oref']] != '' 
    162. 

  162.                 ) {
    163. 

  163.                 $ref = $object[$o['fields'][$history['table_field']]['oref']];
    164. 

  164.                 ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'syncObjectLoad');
    165. 

  165.                 $rc = ciniki_core_syncObjectLoad($ciniki, $sync, $tnid, $ref, array());
    166. 

  166.                 if( $rc['stat'] != 'ok' ) {
    167. 

  167.                     return array('stat'=>'fail', 'err'=>array('code'=>'ciniki.core.240', 'msg'=>"Unable to load object $ref"));
    168. 

  168.                 }
    169. 

  169.                 $ref_o = $rc['object'];
    170. 

  170.                 if( !isset($ref_o['type']) || $ref_o['type'] != 'settings' ) {
    171. 

  171.                     ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'syncObjectLookup');
    172. 

  172.                     $rc = ciniki_core_syncObjectLookup($ciniki, $sync, $tnid, $ref_o, 
    173. 

  173.                         array('local_id'=>$history['new_value']));
    174. 

  174.                     if( $rc['stat'] != 'ok' ) {
    175. 

  175.                         return array('stat'=>'fail', 'err'=>array('code'=>'ciniki.core.241', 'msg'=>'Unable to find reference for ' . $ref_o['name'] . '(' . $history['new_value'] . ')', 'err'=>$rc['err']));
    176. 

  176.                     }
    177. 

  177.                     $object['history'][$uuid]['new_value'] = $rc['uuid'];
    178. 

  178.                 }
    179. 

  179.             }
    180. 

  180.             elseif( isset($o['fields'][$history['table_field']]) && isset($o['fields'][$history['table_field']]['ref']) && $history['new_value'] != '0' ) {
    181. 

  181.                 $ref = $o['fields'][$history['table_field']]['ref'];
    182. 

  182.                 ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'syncObjectLoad');
    183. 

  183.                 $rc = ciniki_core_syncObjectLoad($ciniki, $sync, $tnid, $ref, array());
    184. 

  184.                 if( $rc['stat'] != 'ok' ) {
    185. 

  185.                     return array('stat'=>'fail', 'err'=>array('code'=>'ciniki.core.242', 'msg'=>"Unable to load object $ref"));
    186. 

  186.                 }
    187. 

  187.                 $ref_o = $rc['object'];
    188. 

  188.                 ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'syncObjectLookup');
    189. 

  189.                 $rc = ciniki_core_syncObjectLookup($ciniki, $sync, $tnid, $ref_o, 
    190. 

  190.                     array('local_id'=>$history['new_value']));
    191. 

  191.                 if( $rc['stat'] != 'ok' ) {
    192. 

  192.                     return array('stat'=>'fail', 'err'=>array('code'=>'ciniki.core.243', 'msg'=>'Unable to find reference for ' . $ref_o['name'] . '(' . $history['new_value'] . ')', 'err'=>$rc['err']));
    193. 

  193.                 }
    194. 

  194.                 $object['history'][$uuid]['new_value'] = $rc['uuid'];
    195. 

  195.             }
    196. 

  196.         }
    197. 

  197.     }
    198. 

  198.     
    199. 

  199.     //
    200. 

  200.     // Check if there is a details table for this object, and get the details and history
    201. 

  201.     //
    202. 

  202.     if( isset($o['details']) && isset($o['details']['key']) && isset($o['details']['table']) ) {
    203. 

  203.         //
    204. 

  204.         // Build the SQL string to get the object details along with history information
    205. 

  205.         //
    206. 

  206.         $key = $o['details']['key'];
    207. 

  207.         $table = $o['details']['table'];
    208. 

  208.         $strsql = "SELECT $table.detail_key, $table.detail_value, "
    209. 

  209.             . "UNIX_TIMESTAMP($table.date_added) AS date_added, "
    210. 

  210.             . "UNIX_TIMESTAMP($table.last_updated) AS last_updated, ";
    211. 

  211. 

  212.         $history_table = $o['history_table'];
    213. 

  213.         $strsql .= "$history_table.id AS history_id, "
    214. 

  214.             . "$history_table.uuid AS history_uuid, "
    215. 

  215.             . "ciniki_users.uuid AS user_uuid, "
    216. 

  216.             . "$history_table.session, "
    217. 

  217.             . "$history_table.action, "
    218. 

  218.             . "$history_table.table_field, "
    219. 

  219.             . "$history_table.new_value, "
    220. 

  220.             . "UNIX_TIMESTAMP($history_table.log_date) AS log_date ";
    221. 

  221. 

  222.         $strsql .= "FROM $table "
    223. 

  223.             . "LEFT JOIN $history_table ON ($table.detail_key = $history_table.table_key "
    224. 

  224.                 . "AND $history_table.tnid = '" . ciniki_core_dbQuote($ciniki, $tnid) . "' "
    225. 

  225.                 . "AND $history_table.table_name = '$table' "
    226. 

  226.                 . ") "
    227. 

  227.             . "LEFT JOIN ciniki_users ON ($history_table.user_id = ciniki_users.id) ";
    228. 

  228. 

  229.         $strsql .= "WHERE $table.tnid = '" . ciniki_core_dbQuote($ciniki, $tnid) . "' "
    230. 

  230.             . "AND $table.$key = '" . ciniki_core_dbQuote($ciniki, $object['id']) . "' "
    231. 

  231.             . "ORDER BY log_date ";
    232. 

  232.         $rc = ciniki_core_dbHashQueryIDTree($ciniki, $strsql, $o['pmod'], array(
    233. 

  233.             array('container'=>'details', 'fname'=>'detail_key', 
    234. 

  234.                 'fields'=>array('detail_value', 'date_added', 'last_updated')),
    235. 

  235.             array('container'=>'history', 'fname'=>'history_uuid', 
    236. 

  236.                 'fields'=>array('user'=>'user_uuid', 'session', 
    237. 

  237.                     'action', 'table_field', 'new_value', 'log_date')),
    238. 

  238.             ));
    239. 

  239.         if( $rc['stat'] != 'ok' ) {
    240. 

  240.             return array('stat'=>'fail', 'err'=>array('code'=>'ciniki.core.244', 'msg'=>'Error retrieving the ' . $o['name'] . ' information', 'err'=>$rc['err']));
    241. 

  241.         }
    242. 

  242. 

  243.         if( !isset($rc['details']) ) {
    244. 

  244.             $object['details'] = array();
    245. 

  245.         } else {
    246. 

  246.             $object['details'] = $rc['details'];
    247. 

  247.         }
    248. 

  248.     }
    249. 

  249. 

  250.     return array('stat'=>'ok', 'object'=>$object);
    251. 

  251. }
    252. 

  252. ?>
    253.