// If vPod Status is 2 (Pending) & Reservation is Active
if($sql_lab_vpd_grp_status=='2' && $sql_trx_rsv_grp!='0') {
// Update Pod Status to 3 (Provisioned)
$sql_update_values_grp = array(
'lab_vpd_grp_status'=>'3'
);
$sql_update_exec_grp = sql_update('lab_vpd_grp',$sql_update_values_grp,$lab_vpd_grp);
} // if($sql_lab_vpd_grp_status=='2' && $sql_trx_rsv_grp!='0')
////
} // if($sql_lab_vpd_grp!='0')
// Update Job Group Status to Complete
$sql_update_table = 'lab_job_grp';
$sql_update_values = array(
'lab_job_grp_date_complete' => date('Y-m-d H:i:s'),
"lab_job_grp_status" => '4'
);
$sql_update_exec = sql_update($sql_update_table,$sql_update_values,$lab_job_grp);
sdk_log('info','JOB GROUP COMPLETED','[User '.$sdk_act_usr.'] Job Group #'.$lab_job_grp.' has completed. Status set to Closed (4).','lab_job_grp',$lab_job_grp);
?>
// Select Pod with Reservation
$sql_first_lab_vpd_grp = sql_first($model_lab_vpd_grp,array('lab_vpd_grp.trx_rsv_grp'=>$sql_trx_rsv_grp));
// Define Variables for Database Row
$sql_lab_vpd_grp = $sql_first_lab_vpd_grp['lab_vpd_grp'];
$sql_lab_vnd_uid = $sql_first_lab_vpd_grp['lab_vnd_uid'];
$sql_update_table = 'lab_vpd_grp';
$sql_update_index = $sql_lab_vpd_grp;
$sql_update_values = array(
'trx_rsv_grp' => '0',
$sql_update_table.'_status' => '2'
);
$sql_update_exec = sql_update($sql_update_table,$sql_update_values,$sql_update_index);
sdk_log('info','SQL UPDATE','[labstack-agent:/app/controllers/scrub.php] Pod #'.$sql_update_index.' is no longer associated with Reservation #'.$sql_trx_rsv_grp.'. Reservation number updated to NULL (0).',$sql_update_table,$sql_update_index);
// sdk_log('info','SQL UPDATE','[labstack-agent:/app/controllers/scrub.php] Pod #'.$sql_update_index.' is scheduled to be reverted. Status updated to Pending (2).',$sql_update_table,$sql_update_index);
/**
*
* Create Job Group for Cleanup Job Actions
*
*/
$sql_insert_table = 'lab_job_grp';
$sql_insert_values = array(
'lab_job_cat' => '100004',
'sdk_act_usr' => $sql_sdk_act_usr,
'trx_rsv_grp' => $sql_trx_rsv_grp,
'lab_vnd_uid' => $sql_lab_vnd_uid,
'lab_vpd_grp' => $sql_lab_vpd_grp
