retrieve_view_from_coll_id($coll_id); if(empty($view)) { $view = $sec->retrieve_table_from_coll($coll_id); } $db = new dbquery(); $db->connect(); //$db->query("select docserver_id, path, filename from ".$view." where res_id = ".$res_id); $db->query("select docserver_id from res_view_attachments where res_id_master = " . $res_id . " order by res_id desc"); while ($res = $db->fetch_object()) { $docserver_id = $res->docserver_id; break; } $db->query("select path_template from ".$_SESSION['tablename']['docservers']." where docserver_id = '".$docserver_id."'"); $res = $db->fetch_object(); $docserver_path = $res->path_template; $db->query("select filename, path,title,res_id,res_id_version,attachment_type from res_view_attachments where res_id_master = " . $res_id . " AND status <> 'OBS' AND status <> 'SIGN' AND status <> 'DEL' and attachment_type IN ('response_project','signed_response') order by creation_date asc"); $array_reponses = array(); $cpt_rep = 0; while ($res2 = $db->fetch_object()){ $filename=$res2->filename; $path = preg_replace('/#/', DIRECTORY_SEPARATOR, $res2->path); $filename_pdf = str_replace(pathinfo($filename, PATHINFO_EXTENSION), "pdf",$filename); if (file_exists($docserver_path.$path.$filename_pdf)){ $array_reponses[$cpt_rep]['path'] = $docserver_path.$path.$filename_pdf; $array_reponses[$cpt_rep]['title'] = $res2->title; $array_reponses[$cpt_rep]['attachment_type'] = $res2->attachment_type; if ($res2->res_id_version == 0){ $array_reponses[$cpt_rep]['res_id'] = $res2->res_id; $array_reponses[$cpt_rep]['is_version'] = 0; } else{ $array_reponses[$cpt_rep]['res_id'] = $res2->res_id_version; $array_reponses[$cpt_rep]['is_version'] = 1; } $cpt_rep++; } } return $array_reponses; } /*************/ $res_id = $_REQUEST['res_id']; $coll_id = $_REQUEST['coll_id']; require_once "modules" . DIRECTORY_SEPARATOR . "visa" . DIRECTORY_SEPARATOR . "class" . DIRECTORY_SEPARATOR . "class_modules_tools.php"; include('apps'.DIRECTORY_SEPARATOR.$_SESSION['config']['app_id'].DIRECTORY_SEPARATOR.'definition_mail_categories.php'); require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_request.php"); $core =new core_tools(); $data = get_general_data($coll_id, $res_id, 'minimal'); /* Partie centrale */ // AVANCEMENT $avancement_html = ''; $avancement_html .= '

'. _WF .'

'; $avancement_html .= ''; $avancement_html .= '
'; $avancement_html .= '
'; $avancement_html .= ''; $avancement_html .= '<<'; $avancement_html .= ' '. _ALL_HISTORY .''; $avancement_html .= ''; $avancement_html .= ''; require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_security.php"); $sec =new security(); //PJ $countAttachments = "select res_id from res_view_attachments where status NOT IN ('DEL','OBS') and res_id_master = " . $res_id . " and coll_id = '" . $coll_id . "'"; $dbAttach = new dbquery(); $dbAttach->query($countAttachments); if ($dbAttach->nb_result() > 0) { $nb_attach = ' (' . ($dbAttach->nb_result()). ')'; } $pj_html_dt = _ATTACHED_DOC .$nb_attach; $pj_html_dd = ''; if ($core->is_module_loaded('attachments')) { require 'modules/templates/class/templates_controler.php'; $templatesControler = new templates_controler(); $templates = array(); $templates = $templatesControler->getAllTemplatesForProcess($curdest); $_SESSION['destination_entity'] = $curdest; //var_dump($templates); $pj_html_dd .= '

'; $pj_html_dd .= '

' . _PJ . ', ' . _ATTACHEMENTS . '

'; $req = new request; $req->connect(); $req->query("select res_id from ".$_SESSION['tablename']['attach_res_attachments'] . " where (status = 'A_TRA' or status = 'TRA') and res_id_master = " . $res_id . " and coll_id = '" . $coll_id . "'"); //$req->show(); $nb_attach = 0; if ($req->nb_result() > 0) { $nb_attach = $req->nb_result(); } $pj_html_dd .= '

'; $pj_html_dd .= ''; if ($core->is_module_loaded('templates')) { $pj_html_dd .= ''; } $pj_html_dd .= ''; $pj_html_dd .= '

'; $pj_html_dd .= '

'; } $frm_str .= ''; //NOTES if ($core->is_module_loaded('notes')){ require_once "modules" . DIRECTORY_SEPARATOR . "notes" . DIRECTORY_SEPARATOR . "class" . DIRECTORY_SEPARATOR . "class_modules_tools.php"; $notes_tools = new notes(); //Count notes $nbr_notes = $notes_tools->countUserNotes($res_id, $coll_id); if ($nbr_notes > 0 ) $nbr_notes = ' ('.$nbr_notes.')'; else $nbr_notes = ''; //Notes iframe $notes_html_dt = _NOTES.$nbr_notes; $notes_html_dd = '

'. _NOTES .'

'; } /* Partie droite */ $right_html = ''; if ($core->test_service('sendmail', 'sendmail', false) === true) { require_once "modules" . DIRECTORY_SEPARATOR . "sendmail" . DIRECTORY_SEPARATOR . "class" . DIRECTORY_SEPARATOR . "class_modules_tools.php"; $sendmail_tools = new sendmail(); //Count mails $nbr_emails = $sendmail_tools->countUserEmails($res_id, $coll_id); if ($nbr_emails > 0 ) $nbr_emails = ' ('.$nbr_emails.')'; else $nbr_emails = ''; $right_html .= '

' . _SENDED_EMAILS.$nbr_emails .'

'; //Emails iframe $right_html .= $core->execute_modules_services( $_SESSION['modules_services'], 'details', 'frame', 'sendmail', 'sendmail' ); $right_html .= '

'; } //Onglet Circuit $right_html .= '

'._VISA_WORKFLOW.'

'; $right_html .= '

'._VISA_WORKFLOW.'

'; $modifVisaWorkflow = false; if ($core->test_service('config_visa_workflow', 'visa', false)) { $modifVisaWorkflow = true; } $visa = new visa(); $right_html .= '

'; $right_html .= '

'; $right_html .= $visa->getList($res_id, $coll_id, $modifVisaWorkflow, 'VISA_CIRCUIT'); $right_html .= '

'; /* Historique diffusion visa */ $right_html .= '
'; $right_html .= '
'; $right_html .= ''; $right_html .= '<<'; $right_html .= ' '._DIFF_LIST_VISA_HISTORY.''; $right_html .= ''; $right_html .= ''; $right_html .= '

'; $valid_but = 'valid_action_form( \\\'index_file\\\', \\\'index.php?display=true&page=manage_action&module=core\\\', \\\''.$_REQUEST['action'].'\\\', \\\''.$res_id.'\\\', \\\'res_letterbox\\\', \\\'null\\\', \\\''.$coll_id.'\\\', \\\'page\\\');'; echo "{status : 3,notes_dt:'".$notes_html_dt."',notes_dd:'".$notes_html_dd."',pj_dt:'".$pj_html_dt."',pj_dd:'".$pj_html_dd."',avancement:'".$avancement_html."',right_html:'".$right_html."',valid_button:'".$valid_but."'}"; exit(); ?>