superedit-IN7_POST_HISTORY.php 1.1 KB

1234567891011121314151617181920212223242526272829303132333435363738394041
  1. <?php
  2. //echo "<BR>superedit-superedit-IN7_POST_HISTORY.php";
  3. function IN7_POST_HISTORY($TABLE,$FIELDS,$VALUES,$thiss,$SESSION) {
  4. //$ZAP_FIELDS
  5. //$ZAP_VAL
  6. $I=0;
  7. foreach($FIELDS as $FIELDS_V) {
  8. $ZAP_FIELDS.=", $FIELDS_V ";
  9. $ZAP_VAL.=", '".$VALUES[$I]."'";
  10. $ZAP_UPD.=", $FIELDS_V='".$VALUES[$I]."' ";
  11. $I++;
  12. }
  13. //
  14. $ZAP_FIELDS="ID_USERS2, A_RECORD_UPDATE_DATE , A_RECORD_UPDATE_AUTHOR ".$ZAP_FIELDS;
  15. $ZAP_VAL=" '".$_SESSION[$thiss->DETECT_TABLE_COLUMN][EDITRECORD][ID]."', now() , '".$_SESSION[ADM_ACCOUNT]."' ".$ZAP_VAL;
  16. //, A_RECORD_UPDATE_DATE=now(), A_RECORD_UPDATE_AUTHOR='system-imported'
  17. $ZAP_HIST="INSERT INTO ".$thiss->DETECT_TABLE_NAME."_HIST ($ZAP_FIELDS) VALUES ($ZAP_VAL) ; ";
  18. $ZAP_UPD="UPDATE ".$thiss->DETECT_TABLE_NAME." SET A_RECORD_UPDATE_DATE=now() , A_RECORD_UPDATE_AUTHOR='".$_SESSION[ADM_ACCOUNT]."' ".$ZAP_UPD." where ID='".$_SESSION[$thiss->DETECT_TABLE_COLUMN][EDITRECORD][ID]."' limit 1 ;" ;
  19. echo "<br> ZAP_HIST $ZAP_HIST ";
  20. echo "<br> ZAP_UPD $ZAP_UPD ";
  21. //TODO check verify
  22. ZAP_SQL($ZAP_HIST);
  23. ZAP_SQL($ZAP_UPD);
  24. //print_r($thiss);
  25. //print_r($_SESSION);
  26. }