Mar 25th, 2014, 12:46 AM
Hi Joe, thanks for your answer !
This is the code (in the saving tab of the custom field module) that generates my document-code:
$tmp_doc_prj_id = $vars['data']['doc_prj_name'];
// Nome E Codice Progetto Da ricavare via query al DB progetti
$query = mysql_query("SELECT prj_code FROM ft_form_15 WHERE submission_id = $tmp_doc_prj_id AND is_finalized = 'yes'");
$results = mysql_fetch_array($query);
$tmp_prj_code = $results[0];
$query = mysql_query("SELECT prj_name FROM ft_form_15 WHERE submission_id = $tmp_doc_prj_id AND is_finalized = 'yes'");
$results = mysql_fetch_array($query);
$tmp_prj_name = $results[0];
// Numero Documento da ricavare via query usando prj_id e doc_type
$tmp_doc_type = $vars['data']['doc_doc_type'];
$tmp_doc_colum = prj_.$tmp_doc_type._nr;
$query = mysql_query("SELECT $tmp_doc_colum FROM ft_form_15 WHERE submission_id = $tmp_doc_prj_id AND is_finalized = 'yes'");
$results = mysql_fetch_array($query);
$tmp_doc_code = $tmp_doc_type.str_pad($results[0] + 1, 2, "0", STR_PAD_LEFT);
// Mittente e destinatario da ricavare via query al DB progetti
$tmp_doc_mitt_id = $vars['data']['doc_doc_mittente'];
$tmp_doc_dest_id = $vars['data']['doc_doc_dest'];
$query = mysql_query("SELECT cont_code FROM ft_form_16 WHERE submission_id = $tmp_doc_mitt_id AND is_finalized = 'yes'");
$results = mysql_fetch_array($query);
$tmp_doc_mitt_name = $results[0];
$query = mysql_query("SELECT cont_code FROM ft_form_16 WHERE submission_id = $tmp_doc_dest_id AND is_finalized = 'yes'");
$results = mysql_fetch_array($query);
$tmp_doc_dest_name = $results[0];
$value = $tmp_prj_code.$tmp_prj_name."-".$tmp_doc_mitt_name."-".$tmp_doc_dest_name."-".$tmp_doc_code;
And this is an example of resulting document-code displayed in the form-view but not in the Edit Submission page of the same record:
14026LSD14-GEOPH-ISMBO-CT01
Thanks for your help !
Marco
This is the code (in the saving tab of the custom field module) that generates my document-code:
$tmp_doc_prj_id = $vars['data']['doc_prj_name'];
// Nome E Codice Progetto Da ricavare via query al DB progetti
$query = mysql_query("SELECT prj_code FROM ft_form_15 WHERE submission_id = $tmp_doc_prj_id AND is_finalized = 'yes'");
$results = mysql_fetch_array($query);
$tmp_prj_code = $results[0];
$query = mysql_query("SELECT prj_name FROM ft_form_15 WHERE submission_id = $tmp_doc_prj_id AND is_finalized = 'yes'");
$results = mysql_fetch_array($query);
$tmp_prj_name = $results[0];
// Numero Documento da ricavare via query usando prj_id e doc_type
$tmp_doc_type = $vars['data']['doc_doc_type'];
$tmp_doc_colum = prj_.$tmp_doc_type._nr;
$query = mysql_query("SELECT $tmp_doc_colum FROM ft_form_15 WHERE submission_id = $tmp_doc_prj_id AND is_finalized = 'yes'");
$results = mysql_fetch_array($query);
$tmp_doc_code = $tmp_doc_type.str_pad($results[0] + 1, 2, "0", STR_PAD_LEFT);
// Mittente e destinatario da ricavare via query al DB progetti
$tmp_doc_mitt_id = $vars['data']['doc_doc_mittente'];
$tmp_doc_dest_id = $vars['data']['doc_doc_dest'];
$query = mysql_query("SELECT cont_code FROM ft_form_16 WHERE submission_id = $tmp_doc_mitt_id AND is_finalized = 'yes'");
$results = mysql_fetch_array($query);
$tmp_doc_mitt_name = $results[0];
$query = mysql_query("SELECT cont_code FROM ft_form_16 WHERE submission_id = $tmp_doc_dest_id AND is_finalized = 'yes'");
$results = mysql_fetch_array($query);
$tmp_doc_dest_name = $results[0];
$value = $tmp_prj_code.$tmp_prj_name."-".$tmp_doc_mitt_name."-".$tmp_doc_dest_name."-".$tmp_doc_code;
And this is an example of resulting document-code displayed in the form-view but not in the Edit Submission page of the same record:
14026LSD14-GEOPH-ISMBO-CT01
Thanks for your help !
Marco