#id of currently logged in user
$oDate = new Date(time());
$datetime = $oDate->mysql_datetime;
/** ** ** ** ** ** ** ** ** **
* SEE IF RECORD IS ALREADY CHECKED OUT
*/
$query = "SELECT `checked_out`,`checked_out_id`,`checked_out_time` FROM `{$table}` WHERE `{$prikey}` = {$id} LIMIT 1";
$oDB = new db($query);
$checkedout = count($oDB->rows) ? $oDB->rows[0]['checked_out'] : 0;
$checkedout_id = count($oDB->rows) ? $oDB->rows[0]['checked_out_id'] : 0;
$checkedout_time = count($oDB->rows) ? $oDB->rows[0]['checked_out_time'] : 0;
/** ** ** ** ** ** ** ** ** **
* RECORD IS CHECKED OUT SO FIND OUT
* WHO HAS IT AND ALERT THE USER
*/
$checkedout_username = $checkedout_id > 0 ? aimsys::_getUsername($checkedout_id) : false;
if ($checkedout == 1) {
// record is already checked out by another user
$return = <<<HTML
checkout_message('That record is currently being edited by {$checkedout_username}.','error');
\$('.main-content.active .part.active #lb-edit').removeClass('ui-disabled').attr('disabled',false);
HTML;
} else {
// checkout record
$update = "UPDATE `{$table}` SET `checked_out` = 1,`checked_out_id` = {$userid}, `checked_out_time` = '{$datetime}' WHERE `{$prikey}` = {$id} LIMIT 1";
$oDB = new db($update);
if ($oDB->ret['msg_class'] == 'success') {
$return = <<<HTML
checkout_message('Record ready to edit.','success');
\$('.main-content.active .part.active #lb-edit').hide();
\$('.main-content.active .part.active #lb-refresh').hide();
