function processReportUpload()
{
// Build filepath
$uploadfile = getcwd() . '/tmp/' . basename($_FILES['file']['name']);
// If move from temp PHP directory == success, then true
if (move_uploaded_file($_FILES['file']['tmp_name'], $uploadfile)) {
// Check to see if this is a duplicate report
$isDuplicate = getReportData(NULL, gps('report_name'));
if ($isDuplicate) {
unlink($uploadfile);
// Put result in a encoded JSON return
$out = array("result" => 'duplicate', "report_name" => $isDuplicate['report_name'], "description" => $isDuplicate['short_description'], "report_id" => $out['report_id']);
return json_encode($out);
}
//// Start building query
// Get the file as binary
$report_data = file_get_contents($uploadfile);
// Report Name - Used to check for duplicates
$report_name = gps('report_name');
// Report Short Description
$short_description = gps('short_description');
// New Report?
$reportStatus = gps('reportNew');
// Author ID
$aud = gps('report_author_id');
$report_owner_author_id = $aud;
$report_the_user_id = $aud;
// Scope of Data
$report_type_id = gps('report_type_id');
// Scope of Data
$report_scope_id = gps('report_scope_id');
// Publication Number
$pid = gps('report_number');
// Filename
$report_file_name = basename($_FILES['file']['name']);
// Publication Date. Tenatively date of import.
$report_publication_date = date("m-d-y");
// xx-xx-xxxx
// report filesize
$report_file_size = filesize($uploadfile);
// set report ID to null if it is a new report, otherwise, use $stored_report_id
//$report_id = ($reportStatus == 0) ? NULL : $reportStatus;
// Build Parameters
$spParams = array(array(NULL, 1), array(NULL, 1), array($report_owner_author_id, 1), array($report_id, 1), array($report_name, 1), array($short_description, 1), array($pid, 1), array($report_publication_date, 1), array(1, 1), array($report_type_id, 1), array('http://', 1), array(1, 1), array($report_file_size, 1), array($report_file_name, 1), array($report_file_name, 1), array('pdf', 1), array('application/pdf', 1), array(1, 1), array($report_data, SQLSRV_PARAM_IN, SQLSRV_PHPTYPE_STREAM(SQLSRV_ENC_BINARY)), array(1, 1), array($report_scope_id, 1), array($report_the_user_id, 1));
// call the procedure
$result = callStoredProcedure(sqlsrvConnect(), 'Report_WyomingTobaccoEdit_SP', $spParams);
// if JSON result TRUE
if ($result['success']) {
unlink($uploadfile);
// Delete uploaded file as its now in DB
// prepare JSON data pairs in to array
$out = array("result" => 'success', "post_ID" => gps('post_ID'), "description" => gps('short_description'), "category" => gps('category'), "scope" => gps('sod'), "publication_number" => gps('pid'), "report_id" => $result['report_id'], "report_name" => $result['report_name']);
// return array as json
return json_encode($out);
} else {
$error = print_r($result, TRUE);
// if anything else, return error
$out = array("result" => "error" . $error);
return json_encode($out);
}
}
}
function wysac_delete_saved_report()
{
global $wpdb;
include "processReportUpload.php";
$conn = sqlsrvConnect();
// Used only with MYSQL
$post_id = $_POST['post_id'];
// Use donly with SQLSRV
$report_author_id = $_POST['report_author_id'];
$report_id = $_POST['report_id'];
/** Begin SQL Srv SP Call **/
$spParams = array(array(NULL, 1), array(NULL, 1), array($report_id, 1), array($report_author_id, 1));
$sp = "{ call dbo.ReportDelete_SP(?,?,?,?) }";
$result = sqlsrv_query($conn, $sp, $spParams);
/** End SQL Srv SP Call **/
if ($result) {
// if SQLSRV return TRUE
if ($wpdb->delete('wp_wysac_pdf_id', array('post_id' => $post_id), $where_format = null)) {
// if WPDB return TRUE
return json_encode(array('deleted' => 'true', 'post_id' => $report_id));
} else {
return json_encode(array('deleted' => 'false', 'db' => 'mysql'));
}
} else {
return json_encode(array('deleted' => 'false', 'db' => 'sqlsrv'));
}
}
