AppGini Community Forums

Code: Select all

function compliance_after_insert($data, $memberInfo, &$args){
global $old_data;

foreach($data as $field => $value){
$messageData .= "$field: $value \n";
}

$recID=mysql_insert_id();
sql("insert into membership_userrecords set tableName='compliance' , pkValue='#recID', 
memberID=' ".getLoggedMemberID()."', dateAdded=' ".time()."', dateUpdated='".time()."',
groupID= ".getLoggedGroupID().".", $eo);
 
@mail(
// mail recipient
"[email protected]",
 
// subject
"A Record in the Driver Compliance table of the database was NEWLY CREATED -notification - Driver RECORD NUMBER-{$data['Record_Id']}",
 
// message
      "The above record {$data['Record_Id']} was just modified by: {$memberInfo['username']} The record was updated on and by user id: {$data['LastUpdatedby']},\n. To view the record please go to \n http://MyDomainName.com/MyAppGiniFolder/MyTableName_view.php?SelectedID=".$data['selectedID']."  Newly entered data shows as actual table values below:,
	 {$messageData}  The user that changed this record did so from IP Address: {$memberInfo['IP']}  \n\n", 
	  
 
// sender address
"[email protected]"
);


//Now Capture and log changes to compliance record into the Compliance History Log table called Comp_Hist_Log
sql("INSERT INTO `Comp_Hist_Log` (`Com_Rec_Id`, `old_data`, `new_data`, `ChangedDate`, `ChangedBy`) VALUES('{$data['Record_Id']}', '{$CapoldData}', '{$messageData}', '{$data['LastUpdated']}', '{$memberInfo['username']}')", $eo);
		return TRUE;


	}

Code: Select all

function compliance_after_update($data, $memberInfo, &$args){

global $old_data;

foreach($data as $field => $value){
$messageData .= "$field: $value \n";
}
$recID=mysql_insert_id();
sql("insert into membership_userrecords set tableName='compliance' , pkValue='#recID', 
memberID=' ".getLoggedMemberID()."', dateAdded=' ".time()."', dateUpdated='".time()."',
groupID= ".getLoggedGroupID().".", $eo);
 
@mail(
// mail recipient
"[email protected]",
 
// subject
"A Record in the Driver Compliance table of the database was changed - notification - Driver RECORD NUMBER-{$data['Record_Id']}",
 
// message
      "The above record {$data['Record_Id']} was just modified by:{$memberInfo['username']} The record was updated on and by:{$data['LastUpdatedby']} \n To view the record please go to \n http://domainname.com/appginifolder/compliance_view.php?SelectedID=".$data['selectedID']."  Newly entered data shows as actual table values below:,
	 {$messageData} \n.  The user that changed this record did so from IP Address: {$memberInfo['IP']}  \n\n", 
	  
 
// sender address
"[email protected]"
);
// Capture and log changes to compliance record into the Compliance History Log table
sql("INSERT INTO `Comp_Hist_Log` (`Com_Rec_Id`, `old_data`, `new_data`, `ChangedDate`, `ChangedBy`) VALUES('{$data['Record_Id']}', '{$CapoldData}', '{$messageData}', '{$data['LastUpdated']}', '{$memberInfo['username']}')", $eo);
	
	return TRUE;

	}
	
	

Code: Select all

	function Company_Master_before_update(&$data, $memberInfo, &$args){

#Getting a single field works fine...now working to get all fields...
$selectedID = $data['selectedID'];
$oldcompanyname=sqlValue("select Company_Name from Company_Master where Company_Master_Key='{$data['selectedID']}'");

$res=sql("select * from Company_Master where Company_Master_Key='{$data['selectedID']}'");
while($row=mysql_fetch_row($res)){
#Company_Type_Key 	Percentage_Withheld_From_Payment 	ActiveOrInactive
$thisdbkey = $row[0];
$dboldco = $row[1];
$cotypek = $row[2];
$percenttaken = $row[3];
$isactiverecordornot = $row[4];
}

$res2=sql("select * from Company_Master where Company_Master_Key='{$data['selectedID']}'");
#mysql_fetch_array
while($row2=mysql_fetch_array($res2)){
$dboldcobynamearray = $row2["Company_Name"];
$cotypekbynamearray = $row2["Company_Type_Key"];
}

// log file
#Despite the filename, so far I'm just logging updates before.  I'll adapt this to do _after_update and expect it to work just fine...
$logFile='05052014testlogrecordsbeforeandafterupdates.log';
 
// attempt to open the log file for appending
if(!$fp = @fopen($logFile, 'a')) return;
 
// write log data: date/time, username, IP, record ID
$datetime=date('r');

#'BEFOREUPDATE',Mon, 05 May 2014 16:03:35 -0700,Get Paid Right Now LLC,3,Get Paid Right Now LLC,Get Paid Right Now LLC,1,1 ,10.20,Active,{username works; obscured},{ip #address works; obscured},3

fwrite($fp, "'BEFOREUPDATE',$datetime,$oldcompanyname,$thisdbkey,$dboldco,$dboldcobynamearray,$cotypek,$cotypekbynamearray ,$percenttaken,$isactiverecordornot,{$memberInfo['username']},{$memberInfo['IP']},$selectedID\n");
fclose($fp);

		return TRUE;
	}

Code: Select all

$res=sql("select * from Company_Master where Company_Master_Key='{$data['selectedID']}'");
while($row=mysql_fetch_row($res)){

Code: Select all

foreach($data as $field => $value){
$messageData .= "$field: $value \n";
}

Code: Select all

global $old_data;

foreach($data as $field => $value){
$old_data .= "$field: $value \n";
}

Code: Select all

   function routes_before_update(&$data, $memberInfo, &$args){

$selectedID = $data['selectedID'];
$old_data=sqlValue("select * from routes where ='{$data['selectedID']}'");

//record_id is my primary key in the routes table

$old1=sql("select * from routes where '{$data['record_id']}'='{$data['selectedID']}'");
while($row=mysql_fetch_row($old1)){

//NOT SURE WHAT TO DO WITH THIS PART you have below?? If fields mine to capture are 
/*
  $data['School'], $data['RouteNumber'], $data['County'], $data['school_name'], $data['school_contact'], $data['school_contact_number'], $data['DriverAssigned'], $data['DriverAssignedpm'], $data['UnitAssigned'], $data['PMUnitAssigned'], $data['Lead_driver'], $data['LeadDriverBackUp'], $data['OpsMgr'], $data['Sub_assigned1'], $data['Sub_assigned2'], $data['SpareBusses'], $data['KMLFileLink'], $data['miles'], $data['DateDriverAssigned'], $data['DateDriverUnassigned'], $data['Notes'], $data['RouteStart'], $data['RouteEnd'], $data['FirstStopOnRoute'], $data['LastStopOnRoute'], $data['MorningBellTime'], $data['AfternoonBellTime'], $data['LastUpdated'], $data['DateSubAssigned'], $data['TripSubAssigned'], $data['route_start_date'], $data['route_stop_date'], $data['school_contact_ah'], $data['school_ah_contact'], $data['record_id']
*/


$thisdbkey = $row[0];
$dboldco = $row[1];
$cotypek = $row[2];
$percenttaken = $row[3];
$isactiverecordornot = $row[4];
}

$old2=sql("select * from routes where '{$data['record_id']}'='{$data['selectedID']}'");
#mysql_fetch_array
while($row2=mysql_fetch_array($old2)){
$RouteNumber = $row2["RouteNumber"];
$School = $row2["School"];
}

//I am lost after this part???   Can you help with my fields above and the table name as routes??   Just want to get this right. 

// log file
#Despite the filename, so far I'm just logging updates before.  I'll adapt this to do _after_update and expect it to work just fine...
$logFile='05052014testlogrecordsbeforeandafterupdates.log';
 
// attempt to open the log file for appending
if(!$fp = @fopen($logFile, 'a')) return;
 
// write log data: date/time, username, IP, record ID
$datetime=date('r');

#'BEFOREUPDATE',Mon, 05 May 2014 16:03:35 -0700,Get Paid Right Now LLC,3,Get Paid Right Now LLC,Get Paid Right Now LLC,1,1 ,10.20,Active,{username works; obscured},{ip #address works; obscured},3

fwrite($fp, "'BEFOREUPDATE',$datetime,$oldcompanyname,$thisdbkey,$dboldco,$dboldcobynamearray,$cotypek,$cotypekbynamearray ,$percenttaken,$isactiverecordornot,{$memberInfo['username']},{$memberInfo['IP']},$selectedID\n");
fclose($fp);

      return TRUE;
   }

Code: Select all

function routes_before_update(&$data, $memberInfo, &$args){

/*
To find concepts that I adapted from help, go to the following URL:
http://www.bigprof.com/appgini/help/advanced-topics/hooks/table-specific-hooks#tablename_before_update

And search for: 
makeSafe (which help notes "Also, notice the use of the makeSafe() function which prepares variables 
to be used safely inside SQL queries.")
sql(   (found under tablename_dv()) which retrieves an entire row in a table vs. a single field.)

mysql_fetch_array is not shown in the help file so I adapted what I learned from mysql_fetch_row 
in the appgini help (mysql_fetch_row fetches fields by positionnumber in database which is *not* 
a good way to do it.  (Imagine you have 5 fields initially.  Later you insert another field in the middle 
of the 5 fields.  What used to be field 4 is now field 5, etc so if you just broke all your code...)

mysql_fetch_array fetches the record by field names and number.  (So I reference my field by the actual 
field name rather than field position.)  See:
http://php.net/manual/en/function.mysql-fetch-array.php
/*

$selectedID = makeSafe($data['selectedID']);

//The next line is just *my* example from *my* table where I commented it out with // so see the last line for routes table
//$res2=sql("select * from Company_Master where Company_Master_Key='{$data['selectedID']}'");

    //record_id is my primary key in the routes table (YOUR COMMENT TO ME)
//The SQL statement format is Select * from {tablename} where {databasekeyfield} = '{$data['selectedID']}'");
$res2=sql("select * from routes where record_id='{$data['selectedID']}'");

//If there is at least 1 row returned do what's inside the braces of if(mysql_num_rows($res2))
if(mysql_num_rows($res2)){

//Since we're getting a row *by key* we don't need to loop inside a while.  (Only 1 record should be 
//returned obviously.)  But I'm leaving it in to show if you had *5* child records you could fetch all
//of the "result set" at once.  (Obviously you'd have to insert *what* you wanted to do with the row
//inside of the while in that case where here I know I'm only expecting 1 record.)

while($row2=mysql_fetch_array($res2)){
//Commented out the following line so you can see an example of a field name in *my* table which I assign to a variable.
//$dboldcobynamearray = $row2["Company_Name"];

//$data['DriverAssigned'] $data['miles'] (YOUR COMMENT TO ME)
//To keep things simple I'm only giving 2 examples of fields from your entire list.  Just make a variable
//to hold the contents from the database on the left side of the equal sign and put the field name from 
//database inside double quotes as shown below.
$busdrivername = $row2["DriverAssigned"];
$busroutemiles = $row2["miles"];
}  //End while loop while($row2=mysql_fetch_array($res2))

//To keep this short just refer to my original post as I write the variables out to a log file.
//Open the log file appending data to the old log and write out your variables.
//Example:  You'd write out the variables $busdrivername & $busroutemiles.
//Close log file

} //End if(mysql_num_rows($res2)) (For simplicity, I didn't code an "else" condition if no records found.)

} //End function routes_before_update(&$data, $memberInfo, &$args)