function SaveDocToDb($entry, $file_url, $file_path, $unique_number)
{
global $wpdb;
$table_name = get_tpl_docs_table_name();
if (!empty($entry) && !empty($file_url)) {
$form_id = $entry['form_id'];
$lead_id = $entry['id'];
$form_settings = getTemplateFormSettings(array('where' => 'form_id=' . $form_id));
$name = "";
$email = "";
$query = "SELECT * FROM {$table_name} ";
$query .= " WHERE form_id = " . $form_id . " order by id desc limit 1";
$sql = $query;
$doc_information = $wpdb->get_results($sql, ARRAY_A);
$previous_email = $doc_information[0]['email'];
// echo "previous email $previous_email <br>";
if (!empty($form_settings)) {
$name = $entry[$form_settings[0]['name_id']];
$email = $entry[$form_settings[0]['email_id']];
}
if (!empty($previous_email)) {
$email = $previous_email;
} else {
$usr = wp_get_current_user();
$email = $usr->user_email;
}
//echo "email to be update $email <br>";
$params = array('form_id' => $form_id, 'lead_id' => $lead_id, 'name' => $name, 'email' => $email, 'file_url' => ConvertFileUrl($file_url), 'file_id' => $unique_number, 'file_path' => ConvertDirectoryPath($file_path), 'user_id' => get_current_user_id(), 'cron_status' => 1);
}
$id = TemplateData::insertDocs($params);
}
