';
$frm_str .='
';
$frm_str .='';
$frm_str .='
';
$frm_str .='';
$frm_str .='';
$frm_str .='
';
return addslashes($frm_str);
}
function check_form($form_id,$values)
{
if($form_id == 'frm_redirect_user') {
$user = get_value_fields($values, 'user');
if($user == '')
{
$_SESSION['action_error'] = _MUST_CHOOSE_USER;
return false;
}
else
{
return true;
}
} else {
$_SESSION['action_error'] = _FORM_ERROR;
return false;
}
}
function manage_form($arr_id, $history, $id_action, $label_action, $status, $coll_id, $table, $values_form )
{
if(empty($values_form) || count($arr_id) < 1)
return false;
require_once('modules/entities/class/class_manage_listdiff.php');
$diffList = new diffusion_list();
$visa = new visa();
$content_note = "";
$db = new dbquery();
$db->connect();
$formValues = array();
for($i=0; $iprotect_string_db($content_note);
$date = $db->current_datetime();
$db->query(
"INSERT INTO notes (identifier, tablename, user_id, "
. "date_note, note_text, coll_id ) VALUES ('" . $res_id . "','" . $table . "','" . $userIdTypist . "'," . $date . ",'" . $content_note . "','" . $coll_id . "')"
);
}
}
$circuit = $visa->getWorkflow($res_id, $coll_id, 'VISA_CIRCUIT');
if (count($circuit['sign']) > 0) {
// $up_request = "UPDATE listinstance SET sequence = ".count($circuit['visa']).", item_mode = 'visa', process_date = CURRENT_TIMESTAMP WHERE res_id = ".$res_id." AND item_id='".$_SESSION['user']['UserId']."' AND difflist_type = 'VISA_CIRCUIT' AND process_date ISNULL ";
// $db->query($up_request);
$current_timestamp = date("Y-m-d H:i:s");
$circuit['sign']['users'][0]['process_date'] = $current_timestamp;
if (!isset($circuit['visa']['users'])) {
$circuit['visa']['users'] = array();
}
array_push($circuit['visa']['users'], $circuit['sign']['users'][0]);
}
// $add_request = "INSERT INTO listinstance (coll_id, res_id, sequence, item_id, item_type, item_mode, added_by_user, added_by_entity, difflist_type, process_comment)
// VALUES ('".$coll_id."', ".$res_id.", 0, '".$new_dest."', 'user_id', 'sign', '".$_SESSION['user']['UserId']."', '".$_SESSION['user']['primaryentity']['id']."', 'VISA_CIRCUIT', '".$content_note."')";
// $db->query($add_request);
$circuit['sign']['users'] = array();
array_push($circuit['sign']['users'],
array(
'user_id' => $new_dest,
'process_comment' => $content_note,
'process_date' => "",
'viewed' => 0,
'visible' => 'Y',
'difflist_type' => 'VISA_CIRCUIT'
)
);
unset($_SESSION['visa_wf']);
if (isset($circuit['visa']['users'])) {
$_SESSION['visa_wf']['diff_list']['visa']['users'] = $circuit['visa']['users'];
}
$_SESSION['visa_wf']['diff_list']['sign']['users'] = $circuit['sign']['users'];
// var_dump($_SESSION['visa_wf']['diff_list']);exit;
$visa->saveWorkflow($res_id, $coll_id, $_SESSION['visa_wf']['diff_list'], 'VISA_CIRCUIT');
unset($_SESSION['visa_wf']);
}
$_SESSION['action_error'] = $message;
return array('result' => implode('#', $arr_id), 'history_msg' => $message);
}
function manage_unlock($arr_id, $history, $id_action, $label_action, $status, $coll_id, $table)
{
$db = new dbquery();
$db->connect();
for($i=0; $iquery("update ".$table. " set video_user = '', video_time = 0 where res_id = ".$arr_id[$i], true);
if(!$req)
{
$_SESSION['action_error'] = _SQL_ERROR;
return false;
}
}
return true;
}
/**
* Get the value of a given field in the values returned by the form
*
* @param $values Array Values of the form to check
* @param $field String the field
* @return String the value, false if the field is not found
**/
function get_value_fields($values, $field)
{
for($i=0; $i