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); }