$objPHPExcel->getActiveSheet()->getStyle('N' . $RowCount . ':N' . $RowCount)->applyFromArray($styleThinBlackBorderOutline); $objPHPExcel->getActiveSheet()->getStyle('O' . $RowCount . ':O' . $RowCount)->applyFromArray($styleThinBlackBorderOutline); $objPHPExcel->getActiveSheet()->getStyle('P' . $RowCount . ':P' . $RowCount)->applyFromArray($styleThinBlackBorderOutline); $objPHPExcel->getActiveSheet()->getStyle('A' . $RowCount)->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->getStyle('P' . $RowCount)->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->SetCellValue('A' . $stock_inforamtion, $gTEXT['Stock Information']); $styleThinBlackBorderOutline = array('borders' => array('outline' => array('style' => PHPExcel_Style_Border::BORDER_THIN, 'color' => array('argb' => 'FF000000')))); $objPHPExcel->getActiveSheet()->getStyle('A' . $stock_inforamtion)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $objPHPExcel->getActiveSheet()->getStyle('A' . $stock_inforamtion)->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->duplicateStyleArray(array('font' => array('size' => '13', 'bold' => true)), 'C3'); $objPHPExcel->getActiveSheet()->mergeCells('A' . $stock_inforamtion . ':B' . $stock_inforamtion); $i = 1; $j = $TotalRow; $tempGroupId = ''; while (@($rec = mysql_fetch_array($r))) { $objPHPExcel->getActiveSheet()->SetCellValue('A' . $j, $i)->SetCellValue('B' . $j, $rec['ItemName'])->SetCellValue('C' . $j, checkNullable($rec['OpStock_A']))->SetCellValue('D' . $j, checkNullable($rec['ReceiveQty']))->SetCellValue('E' . $j, checkNullable($rec['DispenseQty']))->SetCellValue('F' . $j, checkNullable($rec['AdjustQty']))->SetCellValue('G' . $j, $rec['AdjustReason'])->SetCellValue('H' . $j, $rec['StockoutDays'])->SetCellValue('I' . $j, $rec['StockOutReasonName'])->SetCellValue('J' . $j, checkNullable($rec['ClStock_A']))->SetCellValue('K' . $j, checkNullable($rec['AMC']))->SetCellValue('L' . $j, checkNull(number_format($rec['MOS'], 1)))->SetCellValue('M' . $j, checkNullable($rec['MaxQty']))->SetCellValue('N' . $j, checkNullable($rec['OrderQty'] < 0 ? 0 : $rec['OrderQty']))->SetCellValue('O' . $j, checkNullable($rec['ActualQty'] < 0 ? 0 : $rec['ActualQty']))->SetCellValue('P' . $j, $rec['OUReason']); $objPHPExcel->getActiveSheet()->getStyle('A' . $j . ':A' . $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $objPHPExcel->getActiveSheet()->getStyle('B' . $j . ':B' . $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $objPHPExcel->getActiveSheet()->getStyle('C' . $j . ':C' . $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT); $objPHPExcel->getActiveSheet()->getStyle('D' . $j . ':D' . $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT); $objPHPExcel->getActiveSheet()->getStyle('E' . $j . ':E' . $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT); $objPHPExcel->getActiveSheet()->getStyle('F' . $j . ':F' . $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT); $objPHPExcel->getActiveSheet()->getStyle('G' . $j . ':G' . $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $objPHPExcel->getActiveSheet()->getStyle('H' . $j . ':H' . $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT); $objPHPExcel->getActiveSheet()->getStyle('I' . $j . ':I' . $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $objPHPExcel->getActiveSheet()->getStyle('J' . $j . ':J' . $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT); $objPHPExcel->getActiveSheet()->getStyle('K' . $j . ':K' . $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT); $objPHPExcel->getActiveSheet()->getStyle('L' . $j . ':L' . $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT); $objPHPExcel->getActiveSheet()->getStyle('M' . $j . ':M' . $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT); $objPHPExcel->getActiveSheet()->getStyle('N' . $j . ':N' . $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT); $objPHPExcel->getActiveSheet()->getStyle('O' . $j . ':O' . $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
$sortfield = $_GET['sortdatafield']; $sortorder = $_GET['sortorder']; if ($sortorder != '') { if ($_GET['filterscount'] == 0) { if ($sortorder == "desc") { $query = "SELECT * from Source ORDER BY" . " " . $sortfield . " DESC LIMIT {$start}, {$pagesize}"; } else { if ($sortorder == "asc") { $query = "SELECT * from Source ORDER BY" . " " . $sortfield . " ASC LIMIT {$start}, {$pagesize}"; } } } else { if ($sortorder == "desc") { $filterquery .= " ORDER BY" . " " . $sortfield . " DESC LIMIT {$start}, {$pagesize}"; } else { if ($sortorder == "asc") { $filterquery .= " ORDER BY" . " " . $sortfield . " ASC LIMIT {$start}, {$pagesize}"; } } $query = $filterquery; } } } $result = mysql_query($query) or die("SQL Error 1: " . mysql_error()); $courses = null; // get data and store in a json array while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $courses[] = array('ID' => checkNull($row['ID'], 0), 'Description' => checkNull($row['Description'], '')); } $data[] = array('TotalRows' => $total_rows, 'Rows' => $courses); echo json_encode($data);
} else { if ($sortorder == "asc") { $query = "SELECT * from Alert_Details ORDER BY" . " " . $sortfield . " ASC LIMIT {$start}, {$pagesize}"; } } } else { if ($sortorder == "desc") { $filterquery .= " ORDER BY" . " " . $sortfield . " DESC LIMIT {$start}, {$pagesize}"; } else { if ($sortorder == "asc") { $filterquery .= " ORDER BY" . " " . $sortfield . " ASC LIMIT {$start}, {$pagesize}"; } } $query = $filterquery; } } } $result = $mysqli->query($query); $courses = null; // get data and store in a json array while ($row = mysqli_fetch_array($result, MYSQL_ASSOC)) { $Alert_Details[] = array('ID' => checkNull($row['ID'], 0), 'Description' => checkNull($row['Description'], '')); } $data[] = array('TotalRows' => $total_rows, 'Rows' => $Alert_Details); echo json_encode($data); } } } } } $mysqli->close();
$status_sql = "insert into redcap_data_quality_status (rule_id, non_rule, project_id, record, event_id, field_name, query_status, assigned_user_id) values (" . checkNull($rule_id) . ", " . checkNull($non_rule) . ", " . PROJECT_ID . ", '" . prep($result['record']) . "', {$result['event_id']}, " . checkNull($field) . ", " . checkNull($dr_status) . ", " . $assigned_user_id . ") on duplicate key update query_status = " . checkNull($dr_status) . ", status_id = LAST_INSERT_ID(status_id)"; if (!$debug) { if (db_query($status_sql)) { // Get cleaner_id $status_id = db_insert_id(); // Get current user's ui_id $userInitiator = User::getUserInfo(USERID); // Add new row to data_resolution_log $sql = "insert into redcap_data_quality_resolutions (status_id, ts, user_id, response_requested, response, comment, current_query_status, upload_doc_id) values ($status_id, '" . NOW . "', " . checkNull($userInitiator['ui_id']) . ", " . checkNull($response_requested) . ", " . checkNull($response) . ", " . checkNull($rule_info['name']) . ", " . checkNull($dr_status) . ", " . checkNull($_POST['upload_doc_id']) . ")"; if (db_query($sql)) { // Success, so return content via JSON to redisplay with new changes made $res_id = db_insert_id(); ## Logging // Set data values as json_encoded $logDataValues = json_encode(array('res_id' => $res_id, 'record' => $result['record'], 'event_id' => $result['event_id'], 'field' => $field, 'rule_id' => $rule_id)); // Set event_id in query string for logging purposes only $_GET['event_id'] = $result['event_id']; // Log it log_event($sql, "redcap_data_quality_resolutions", "MANAGE", $result['record'], $logDataValues, $drw_log); } else { // ERROR! exit('0'); }
if ($sortorder == "desc") { $filterquery .= " ORDER BY" . " " . $sortfield . " DESC LIMIT {$start}, {$pagesize}"; } else { if ($sortorder == "asc") { $filterquery .= " ORDER BY" . " " . $sortfield . " ASC LIMIT {$start}, {$pagesize}"; } } $query = $filterquery; } } } $result = $mysqli->query($query); $sql = "SELECT FOUND_ROWS() AS `found_rows`;"; $rows = $mysqli->query($sql); $totalrow = mysqli_fetch_assoc($rows); $total_rows = $totalrow['found_rows']; $courses = null; // get data and store in a json array while ($row = mysqli_fetch_array($result, MYSQL_ASSOC)) { $CPD_Details[] = array('ID' => checkNull($row['ID'], 0), 'Name' => checkNull($row['Name'], ''), 'Product_ID' => checkNull($row['Product_ID'], ''), 'Product' => checkNull($row['Product'], ''), 'Category_ID' => checkNull($row['Category_ID'], ''), 'Category' => checkNull($row['Category'], ''), 'Points' => checkNull($row['Points'], ''), 'Accreditation_No' => checkNull($row['Accreditation_No'], ''), 'Dimensions' => checkNull($row['Dimensions'], '')); } $data[] = array('TotalRows' => $total_rows, 'Rows' => $CPD_Details); echo json_encode($data); } } } } } } } $mysqli->close();
/** * @param $record * @param $event_id * @param $group_id * @param $debug */ public static function schedule_surveys($record, $event_id, $group_id, $debug) { global $Proj, $project_id, $user_rights, $table_pk; /** * if the user is in a DAG */ if ($user_rights['group_id'] != "") { /** * does this record exist? */ $q = db_query("SELECT 1 from redcap_data WHERE project_id = $project_id AND record = '$record' LIMIT 1"); if (db_num_rows($q) > 0) { /** * is the record in this users DAG? */ $q = db_query("SELECT 1 from redcap_data WHERE project_id = $project_id AND record = '$record' AND field_name = '__GROUPID__' AND value = '{$user_rights['group_id']}' LIMIT 1"); if (db_num_rows($q) < 1) { /** * record is not in Users DAG! */ REDCap::logEvent('Scheduled record is not in users DAG', '', '', $record, $event_id, $project_id); exit; } } } /** * check to see if the subject has an existing schedule on an existing arm */ $sub = "SELECT DISTINCT e.arm_id from redcap_events_calendar c, redcap_events_metadata e WHERE c.project_id = $project_id AND c.record = '$record' AND c.event_id = e.event_id"; $sched_arm_result = db_query("SELECT arm_num FROM redcap_events_arms WHERE project_id = $project_id AND arm_id IN (" . pre_query($sub) . ")"); if ($sched_arm_result) { $trt = Prioritize::getTrtInfo($record); if ($debug) { error_log(print_r($trt, true)); } $tx_start_date = $trt['rfxstdtc']; $rand_date = $trt['rand_date']; $dates = array(); $arm_num = db_result($sched_arm_result, 0, 'arm_num'); if (isset($arm_num) && $arm_num != '') { // subject has an existing schedule. keep existing event_id > arm structure if ($arm_num != '1') { // make sure we don't put anything in the first arm $q = db_query("SELECT * from redcap_events_metadata m, redcap_events_arms a WHERE a.project_id = $project_id AND a.arm_id = m.arm_id AND a.arm_num = $arm_num order by m.day_offset, m.descrip"); if ($q) { while ($row = db_fetch_assoc($q)) { // if we have no $arm_num, this will be empty /** * get the event date ($rand_date for baseline and $tx_start_date + day_offset) */ $row['day_offset'] = $arm_num != $trt['timing_arm_num'] ? $trt['timing_offsets'][$row['descrip']] : $row['day_offset']; if (in_array($row['descrip'], array('Baseline', 'EOT+1Year', 'EOT+3Year'))) { $this_event_date = isset($rand_date) && $rand_date != '' ? add_date($rand_date, $row['day_offset']) : null; } else { $this_event_date = isset($tx_start_date) && $tx_start_date != '' ? add_date($tx_start_date, $row['day_offset']) : null; } $dates[$row['event_id']] = $this_event_date; } db_free_result($q); } } else { REDCap::logEvent('Scheduling attempted in invalid arm', '', '', $record, $event_id, $project_id); } } else { // subject's schedule is new. put dates into event_ids for this arm $arm_result = db_query("SELECT arm_num FROM redcap_events_arms WHERE project_id = '$project_id' AND arm_name = '{$trt['arm']}'"); if ($arm_result) { $arm_num = db_result($arm_result, 0, 'arm_num'); if ($arm_num != '1') { $q = db_query("SELECT * from redcap_events_metadata m, redcap_events_arms a WHERE a.project_id = $project_id AND a.arm_id = m.arm_id AND a.arm_num = $arm_num order by m.day_offset, m.descrip"); if ($q) { while ($row = db_fetch_assoc($q)) { // if we have no $arm_num, this will be empty /** * get the event date ($rand_date for baseline and $tx_start_date + day_offset) */ if (in_array($row['descrip'], array('Baseline', 'EOT+1Year', 'EOT+3Year'))) { $this_event_date = isset($rand_date) && $rand_date != '' ? add_date($rand_date, $row['day_offset']) : null; } else { $this_event_date = isset($tx_start_date) && $tx_start_date != '' ? add_date($tx_start_date, $row['day_offset']) : null; } $dates[$row['event_id']] = $this_event_date; } db_free_result($q); } } else { REDCap::logEvent('Scheduling attempted in invalid arm', '', '', $record, $event_id, $project_id); } db_free_result($arm_result); } } if ($debug) { error_log(print_r($dates, true)); } if (!empty($dates)) { /** * do we have an existing schedule? */ $sql = "SELECT c.event_date, c.baseline_date, e.* FROM redcap_events_calendar c, redcap_events_metadata e WHERE c.project_id = $project_id AND c.record = '$record' AND c.event_id = e.event_id AND e.arm_id IN (" . pre_query($sub) . ")"; $sched_result = db_query($sql); if ($sched_result) { $sql_all = array(); $sql_errors = array(); if (db_num_rows($sched_result) > 0) { while ($sched_row = db_fetch_assoc($sched_result)) { $base_date = in_array($sched_row['descrip'], array('Baseline', 'EOT+1Year', 'EOT+3Year')) ? $trt['rand_date'] : $trt['rfxstdtc']; /** * if the scheduled date is in the $dates array, we don't care about it, so ignore it and remove from $dates * if we have an existing schedule and the dates have changed, update the schedule and remove from $dates * if the base date has changed, update it and the schedule * whatever is left will be new dates, insert into schedule */ if ($dates[$sched_row['event_id']] == $sched_row['event_date']) { unset($dates[$sched_row['event_id']]); } if (isset($dates[$sched_row['event_id']]) && $dates[$sched_row['event_id']] != '' && $sched_row['event_date'] != $dates[$sched_row['event_id']]) { // the date has changed. update the date. $sql = "UPDATE redcap_events_calendar SET event_date = '{$dates[$sched_row['event_id']]}' WHERE record = '$record' AND project_id = '$project_id' AND group_id = '$group_id' AND event_id = '{$sched_row['event_id']}' AND event_date = '{$sched_row['event_date']}'"; if (!$debug) { if (db_query($sql)) { $sql_all[] = $sql; log_event($sql, "redcap_events_calendar", "MANAGE", $record, $sched_row['event_id'], "Update calendar event"); } else { $sql_errors[] = $sql; } } else { error_log($sql); } unset($dates[$sched_row['event_id']]); } if ($base_date != $sched_row['baseline_date']) { // the base_date has changed. this will only occur if the treatment start date or randomization date are changed in the study. $sql = "UPDATE redcap_events_calendar SET baseline_date = '" . prep($base_date) . "' WHERE record = '$record' AND project_id = '$project_id' AND group_id = '$group_id' AND event_id = '{$sched_row['event_id']}' AND baseline_date = '{$sched_row['baseline_date']}'"; if (!$debug) { if (db_query($sql)) { $sql_all[] = $sql; log_event($sql, "redcap_events_calendar", "MANAGE", $record, $sched_row['event_id'], "Update calendar event"); } else { $sql_errors[] = $sql; } } else { error_log($sql); } unset($dates[$sched_row['event_id']]); } } foreach ($dates AS $date_event_id => $date) { //Loop through dates and add them to the schedule $base_date = in_array($Proj->eventInfo[$date_event_id]['name'], array('Baseline', 'EOT+1Year', 'EOT+3Year')) ? $trt['rand_date'] : $trt['rfxstdtc']; if (isset($date) && $date != "") { //Add to table $sql = "INSERT INTO redcap_events_calendar (record, project_id, group_id, event_id, event_date, event_time, event_status, baseline_date) VALUES ('$record', $project_id, " . checkNull($group_id) . ", '" . prep($date_event_id) . "', '" . prep($date) . "', '" . null . "', 0, '$base_date')"; if (!$debug) { if (db_query($sql)) { $sql_all[] = $sql; } else { $sql_errors[] = $sql; } } else { error_log($sql); } } } log_event(implode(";\n", $sql_all), "redcap_events_calendar", "MANAGE", $_GET['idnumber'], "$table_pk = '$record'", "Perform scheduling"); } else { foreach ($dates AS $date_event_id => $date) { //Loop through dates and add them to the schedule $base_date = in_array($Proj->eventInfo[$date_event_id]['name'], array('Baseline', 'EOT+1Year', 'EOT+3Year')) ? $trt['rand_date'] : $trt['rfxstdtc']; if (isset($date) && $date != "") { //Add to table $sql = "INSERT INTO redcap_events_calendar (record, project_id, group_id, event_id, event_date, event_time, event_status, baseline_date) VALUES ('$record', $project_id, " . checkNull($group_id) . ", '" . prep($date_event_id) . "', '" . prep($date) . "', '" . null . "', 0, '$base_date')"; if (!$debug) { if (db_query($sql)) { $sql_all[] = $sql; } else { $sql_errors[] = $sql; } } else { error_log($sql); } } } log_event(implode(";\n", $sql_all), "redcap_events_calendar", "MANAGE", $_GET['idnumber'], "$table_pk = '$record'", "Perform scheduling"); } } db_free_result($sched_result); } db_free_result($sched_arm_result); } }
$query = "SELECT * from Adviser_Groups ORDER BY" . " " . $sortfield . " DESC LIMIT {$start}, {$pagesize}"; } else { if ($sortorder == "asc") { $query = "SELECT * from Adviser_Groups ORDER BY" . " " . $sortfield . " ASC LIMIT {$start}, {$pagesize}"; } } } else { if ($sortorder == "desc") { $filterquery .= " ORDER BY" . " " . $sortfield . " DESC LIMIT {$start}, {$pagesize}"; } else { if ($sortorder == "asc") { $filterquery .= " ORDER BY" . " " . $sortfield . " ASC LIMIT {$start}, {$pagesize}"; } } $query = $filterquery; } } } $result = $mysqli->query($query); $courses = null; // get data and store in a json array while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { $courses[] = array('ID' => checkNull($row['ID'], 0), 'Group_Description' => checkNull($row['Group_Description'], ''), 'Licensee' => $row['Licensee'], 'Licensee_Email' => $row['Licensee_Email']); } $data[] = array('TotalRows' => $total_rows, 'Rows' => $courses); echo json_encode($data); } } } } $mysqli->close();
$filterquery .= " ORDER BY" . " " . $sortfield . " ASC LIMIT {$start}, {$pagesize}"; } } $query = $filterquery; } } } $result = $mysqli->query($query); $sql = "SELECT FOUND_ROWS() AS `found_rows`;"; $rows = $mysqli->query($sql); $totrows = mysqli_fetch_array($rows, MYSQLI_ASSOC); $total_rows = $totrows['found_rows']; $advisers = array(); // get data and store in a json array while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { $advisers[] = array('ID' => checkNull($row['ID'], 0), 'Adviser_ID' => checkNull($row['Adviser_ID'], ''), 'AR_Number' => checkNull($row['AR_Number'], ''), 'Given_Name' => checkNull($row['Given_Name'], ''), 'Surname' => checkNull($row['Surname'], ''), 'DOB' => checkNull($row['DOB'], ''), 'PostCode' => checkNull($row['PostCode'], ''), 'Email' => checkNull($row['Email'], ''), 'Phone' => checkNull($row['Phone'], ''), 'Mobile' => checkNull($row['Mobile'], ''), 'Group_ID' => checkNull($row['Group_ID'], ''), 'Group' => checkNull($row['Group_Description'], ''), 'Expertise_Areas' => checkNull($row['Expertise_Areas'], ''), 'ASIC_Areas' => checkNull($row['ASIC_Areas'], ''), 'Referral' => checkNull($row['Referral'], ''), 'Licensee' => checkNull($row['Licencee'], ''), 'Practice_Name' => checkNull($row['Practice_Name'], '')); } $data[] = array('TotalRows' => $total_rows, 'Rows' => $advisers); echo json_encode($data); } } } } } } } } } } } }
<?php include "top.php"; $fName = $_POST["fName"]; $lName = $_POST["lName"]; $eMail = $_POST["wEmail"]; checkNull($eMail, "wEmail"); $pwd = base64_encode(gzdeflate($_POST["pswd"])); require 'model/database.php'; $con = connect(); insert($con, "INSERT INTO `student`(`firstName`, `lastName`, `email`, `password`) values('{$fName}','{$lName}','{$eMail}','{$pwd}')"); close($con); function checkNull($input, $fieldName) { if ($input == null) { throw new Exception("Please enter value for " . $fieldName); } } ?> <div id="content"> <div id="box1"> Thank you for signing up! Welcome <?php echo $fName; ?> . Please <a href = "index.php">Login</a> </div> <div id = "box2"> </div> <br class="clear" /> </div>
function FacilityDataEntryReportPDF($conn) { global $gTEXT; global $SITETITLE; $Year = isset($_REQUEST['Year']) ? $_REQUEST['Year'] : ''; $Month = isset($_REQUEST['Month']) ? $_REQUEST['Month'] : ''; $RegionId = isset($_REQUEST['RegionId']) ? $_REQUEST['RegionId'] : ''; $RegionName = isset($_REQUEST['RegionName']) ? $_REQUEST['RegionName'] : ''; $MonthName = isset($_REQUEST['MonthName']) ? $_REQUEST['MonthName'] : ''; $ItemGroupName = isset($_REQUEST['ItemGroupName']) ? $_REQUEST['ItemGroupName'] : ''; $lastyear = getYearForLastMonth($Year, $Month); $lastmonth = getLastMonth($Year, $Month); $CFMStockId = isset($_REQUEST['CFMStockId']) ? $_REQUEST['CFMStockId'] : ''; $CountryId = isset($_REQUEST['CountryId']) ? $_REQUEST['CountryId'] : ''; //$DistrictId = isset($_REQUEST['DistrictId']) ? $_REQUEST['DistrictId'] : ''; //$OwnerTypeId = isset($_REQUEST['OwnerTypeId']) ? $_REQUEST['OwnerTypeId'] : ''; $Year = isset($_REQUEST['YearId']) ? $_REQUEST['YearId'] : ''; $MonthId = isset($_REQUEST['MonthId']) ? $_REQUEST['MonthId'] : ''; $MonthName = isset($_REQUEST['MonthName']) ? $_REQUEST['MonthName'] : ''; $FacilityId = isset($_REQUEST['FacilityId']) ? $_REQUEST['FacilityId'] : ''; require_once 'tcpdf/tcpdf.php'; $pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false); $pdf->SetPrintHeader(false); $pdf->SetPrintFooter(false); $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED); $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT); $pdf->SetHeaderMargin(PDF_MARGIN_HEADER); $pdf->SetFooterMargin(PDF_MARGIN_FOOTER); $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM); $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT); $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO); if (@file_exists(dirname(__FILE__) . '/lang/eng.php')) { require_once dirname(__FILE__) . '/lang/eng.php'; $pdf->setLanguageArray($l); } $pdf->SetDisplayMode('fullpage', 'SinglePage', 'UseNone'); $pdf->SetFont('times', 'B', 20); $pdf->AddPage('L', 'A4'); $sqlf = " SELECT FacilityId, FacilityName FROM t_facility WHERE FacilityId={$FacilityId}"; $resultf = mysql_query($sqlf); $FacilityName = ''; while ($row = mysql_fetch_array($resultf)) { $FacilityName = $row['FacilityName']; } $html3 = '<div class="padding-md clearfix" style="text-align:center;"> <h2 style="text-align:center;">' . $SITETITLE . '</h2> <h4 style="text-align:center;">' . $gTEXT['Facility Level Patient And Stock Status List'] . '</h4> <h5 style="text-align:center;">' . $gTEXT['Facility'] . ': ' . $FacilityName . ', ' . $gTEXT['Month'] . ': ' . $MonthName . ', ' . $gTEXT['Year'] . ': ' . $Year . '<h5> </div>'; $pdf->SetFont('dejavusans', '', 9); $pdf->writeHTMLCell(140, 20, 75, 10, $html3, '', 0, 0, false, 'C', true); //===============================facility data entry Table====================================== function checkNullable($value) { $retVal = ''; if ($value == 0) { $retVal = ''; } else { $retVal = number_format($value); } return $retVal; } function checkNull($value) { $retVal = ''; if ($value == 0) { $retVal = ''; } else { $retVal = $value; } return $retVal; } $sql1 = " SELECT\n\t b.CFMPOId,\n\t a.FormulationName PatientTypeName,\n\t b.RefillPatient,\n\t b.NewPatient,\n\t b.TotalPatient\n\tFROM t_formulation a\n\t INNER JOIN t_cfm_patientoverview b\n\t\tON a.FormulationId = b.FormulationId\n\tWHERE b.CFMStockId = {$CFMStockId}\n\t\tAND FacilityId = {$FacilityId}\n\t\tAND MonthId = {$MonthId}\n\t\tAND YEAR = '" . $Year . "'\n\t\tAND CountryId = {$CountryId}\n\tORDER BY b.CFMPOId ASC"; $result = mysql_query($sql1); $total = mysql_num_rows($result); $sql7 = " SELECT CFMStockId, FacilityId, MonthId, Year, \n\t(SELECT b.name FROM ykx9st_users b WHERE b.username = a.CreatedBy) CreatedBy, DATE_FORMAT(CreatedDt, '%d-%b-%Y %h:%i %p') CreatedDt,\n\t(SELECT b.name FROM ykx9st_users b WHERE b.username = a.LastUpdateBy) LastUpdateBy,\t\n\t(SELECT b.name FROM ykx9st_users b WHERE b.username = a.LastSubmittedBy) LastSubmittedBy ,\n\tc.StatusId, c.StatusName,\n\tDATE_FORMAT(LastUpdateDt, '%d-%b-%Y %h:%i %p') LastUpdateDt,\t\n\tDATE_FORMAT(LastSubmittedDt, '%d-%b-%Y %h:%i %p') LastSubmittedDt,\t\n\tDATE_FORMAT(a.AcceptedDt, '%d-%b-%Y %h:%i %p') AcceptedDt,\t\n\t(SELECT b.name FROM ykx9st_users b WHERE b.username = a.PublishedBy) PublishedBy ,\n\tDATE_FORMAT(a.PublishedDt, '%d-%b-%Y %h:%i %p') PublishedDt \t\n\tFROM t_cfm_masterstockstatus a LEFT JOIN t_status c ON a.StatusId = c.StatusId "; $sql7 .= " WHERE FacilityId = " . $FacilityId . " and MonthId = " . $MonthId . " and Year = '" . $Year . "' AND CountryId = {$CountryId} "; $result7 = mysql_query($sql7); $sql = "SELECT a.CFMStockStatusId, a.FacilityId, a.MonthId, a.Year, a.ItemGroupId, b.ItemSL, a.ItemNo, b.ItemName, OpStock OpStock_A, a.OpStock_C, a.ReceiveQty, a.DispenseQty, a.AdjustQty, a.AdjustId AdjustReason"; $sql .= ",a.StockoutDays, a.StockOutReasonId, a.ClStock ClStock_A, a.ClStock_C, a.ClStockSourceId, a.MOS, a.AMC, a.AMC_C, a.AmcChangeReasonId, a.MaxQty, a.OrderQty, a.ActualQty, a.OUReasonId, \n\t a.UserId, a.LastEditTime, c.ProductSubGroupName FormulationName FROM t_cfm_stockstatus a, t_itemlist b, t_product_subgroup c "; $sql .= " WHERE a.CFMStockId = {$CFMStockId}\n\t\t\t\tAND `YEAR` = '{$Year}'\n\t\t\t\tAND MonthId = {$MonthId}\n\t\t\t\tAND CountryId = 1\n\t\t\t\tAND a.FacilityId = {$FacilityId}\n\t\t\t\tAND a.ItemNo = b.ItemNo\n\t\t\t\tAND b.ProductSubGroupId = c.ProductSubGroupId "; $sql .= " ORDER BY b.ItemSL asc"; $r = mysql_query($sql); $total = mysql_num_rows($r); if ($total > 0) { $data = array(); $i = 0; $getRegimen = ''; $htmlPrint1 = ''; while ($row = mysql_fetch_array($result)) { $htmlPrint1 .= '<tr nobr="true"> <td style="text-align: left; word-wrap: break-word; width:30px;">' . ++$i . '</td> <td style="text-align: left; word-wrap: break-word; width:100px;">' . $row['PatientTypeName'] . '</td> <td style="text-align: right; width:40px;">' . checkNullable($row['TotalPatient']) . '</td> </tr>'; } $htmlC1 = ' <style> .cl{clear:both;} .col4 { width: 260px; height: auto; float: left; overflow: hidden; padding: 20px; background: #00CCCC; font-size:10px; clear: left; } .col4 table, th, td { border: 1px solid black; padding: 2px; } .printw { height: auto; margin: 0 auto 50px; overflow: hidden; width: 1000px; } </style> <div class="col4"> <table style="width: 200px;"> <tr> <th style="text-align: left; word-wrap: break-word; width:170px;" colspan="3"> ' . $gTEXT['Malaria case summary level'] . '</th> </tr> <tr> <th style="text-align: left; width:30px;">' . $gTEXT['SL'] . '</th> <th style="text-align: left; width:100px;">' . $gTEXT['Case Type'] . '</th> <th style="text-align: left; width:40px;">' . $gTEXT['Total'] . '</th> </tr> ' . $htmlPrint1 . ' </table> </div>'; $sql1 = " SELECT\n\t\t\t b.CFMPatientStatusId,\n\t\t\t c.FormulationId,\n\t\t\t c.FormulationName,\n\t\t\t b.RegimenId,\n\t\t\t d.RegimenName RegimenMasterName,\n\t\t\t a.GenderTypeId,\n\t\t\t b.RefillPatient,\n\t\t\t b.NewPatient,\n\t\t\t b.TotalPatient\n\t\t\tFROM t_regimen a\n\t\t\t INNER JOIN t_cfm_regimenpatient b\n\t\t\t ON a.RegimenId = b.RegimenId\n\t\t\t INNER JOIN t_formulation c\n\t\t\t ON a.FormulationId = c.FormulationId\n\t\t\tINNER JOIN t_regimen_master d\n\t\t\t ON a.RegMasterId = d.RegMasterId\n\t\t\tWHERE b.CFMStockId = {$CFMStockId}\n\t\t\t\tAND FacilityId = {$FacilityId}\n\t\t\t\tAND MonthId = {$MonthId}\n\t\t\t\tAND `Year` = '{$Year}'\n\t\t\t\tAND CountryId = {$CountryId}\n\t\t\tORDER BY c.FormulationName, b.RegimenId, a.GenderTypeId desc"; $result1 = mysql_query($sql1); $total = mysql_num_rows($result1); $tmpFormulationId = -1; $i = 0; $htmlPrint2 = ''; while (@($row = mysql_fetch_array($result1))) { if ($tmpFormulationId != @$row['FormulationId']) { if ($i > 0) { $htmlPrint2 .= '</tr>'; } $htmlPrint2 .= '<tr nobr="true"> <td style="text-align: left; word-wrap: break-word; width:30px;">' . ++$i . '</td> <td style="text-align: left; word-wrap: break-word; width:250px;">' . @$row['FormulationName'] . '</td>'; $htmlPrint2 .= '<td style="text-align: right; width:70px;">' . checkNullable(@$row['TotalPatient']) . '</td>'; $tmpFormulationId = @$row['FormulationId']; } else { $htmlPrint2 .= '<td style="text-align: right; width:70px;">' . checkNullable(@$row['TotalPatient']) . '</td>'; $tmpFormulationId = @$row['FormulationId']; } } if ($i > 0) { $htmlPrint2 .= '</tr>'; } $htmlC2 = ' <style> .cl{clear:both;} .col4 { width: 300px; height: auto; float: left; overflow: hidden; padding: 20px; background: #00CCCC; font-size:10px; clear: left; } .col4 table, th, td { border: 1px solid black; padding: 2px; } </style> <div class="col4"> <table style="width: 800px;"> <tr> <th style="text-align: left; word-wrap: break-word; width:770px;" colspan="9"> ' . $gTEXT['Malaria case details'] . '</th> </tr> <tr nobr="true"> <th style="text-align: left; word-wrap: break-word; width:30px;"></th> <th style="text-align: left; word-wrap: break-word; width:250px;"></th> <th style="text-align: center; width:140px;" colspan="2">' . $gTEXT['0-4 Years'] . '</th> <th style="text-align: center; width:140px;" colspan="2">' . $gTEXT['5-14 Years'] . '</th> <th style="text-align: center; width:140px;" colspan="2">' . $gTEXT['15+ Years'] . '</th> <th style="text-align: left; width:70px;"></th> </tr> <tr nobr="true"> <th style="text-align: left; word-wrap: break-word; width:30px;">' . $gTEXT['SL'] . '</th> <th style="text-align: left; word-wrap: break-word; width:250px;">' . $gTEXT['Case Type'] . '</th> <th style="text-align: right; width:70px;">' . $gTEXT['M'] . '</th> <th style="text-align: right; width:70px;">' . $gTEXT['F'] . '</th> <th style="text-align: right; width:70px;">' . $gTEXT['M'] . '</th> <th style="text-align: right; width:70px;">' . $gTEXT['F'] . '</th> <th style="text-align: right; width:70px;">' . $gTEXT['M'] . '</th> <th style="text-align: right; width:70px;">' . $gTEXT['F'] . '</th> <th style="text-align: right; width:70px;">' . $gTEXT['Pregnant Women'] . '</th> </tr> ' . $htmlPrint2 . ' </table> </div>'; $f = 0; $tblHTML = ''; $tempGroupId = ''; while (@($rec = mysql_fetch_array($r))) { $data['SL'][$f] = $f; $data['ItemName'][$f] = @$rec['ItemName']; $data['OpStock_A'][$f] = checkNullable(@$rec['OpStock_A']); $data['ReceiveQty'][$f] = checkNullable(@$rec['ReceiveQty']); $data['ActualQty'][$f] = checkNullable(@$rec['ActualQty']); $data['DispenseQty'][$f] = checkNullable(@$rec['DispenseQty']); $data['AdjustQty'][$f] = checkNullable(@$rec['AdjustQty']); $data['AdjustReason'][$f] = @$rec['AdjustReason']; $data['StockoutDays'][$f] = @$rec['StockoutDays']; $data['StockOutReasonName'][$f] = @$rec['StockOutReasonName']; $data['ClStock_A'][$f] = checkNullable(@$rec['ClStock_A']); $data['AMC'][$f] = checkNullable(@$rec['AMC']); $data['MOS'][$f] = checkNull(number_format(@$rec['MOS'], 1)); $data['MaxQty'][$f] = checkNullable(@$rec['MaxQty']); $data['OrderQty'][$f] = checkNullable(@$rec['OrderQty'] < 0 ? 0 : @$rec['OrderQty']); $data['ActualQty'][$f] = checkNullable(@$rec['ActualQty'] < 0 ? 0 : @$rec['ActualQty']); $data['OUReason'][$f] = @$rec['OUReason']; $tblHTML .= '<tr style="page-break-inside:avoid;"> <td align="center" width="30" valign="middle">' . ($data['SL'][$f] + 1) . '</td> <td align="left" width="157" valign="middle">' . $data['ItemName'][$f] . '</td> <td align="right" width="50" valign="middle">' . $data['OpStock_A'][$f] . '</td> <td align="right" width="50" valign="middle">' . $data['ReceiveQty'][$f] . '</td> <td align="right" width="50" valign="middle">' . $data['DispenseQty'][$f] . '</td> <td align="right" width="50" valign="middle">' . $data['AdjustQty'][$f] . '</td> <td align="left" width="55" valign="middle">' . $data['AdjustReason'][$f] . '</td> <td align="right" width="50" valign="middle">' . $data['StockoutDays'][$f] . '</td> <td align="left" width="55" valign="middle">' . $data['StockOutReasonName'][$f] . '</td> <td align="right" width="50" valign="middle">' . $data['ClStock_A'][$f] . '</td> <td align="right" width="50" valign="middle">' . $data['AMC'][$f] . '</td> <td align="right" width="50" valign="middle">' . $data['MOS'][$f] . '</td> <td align="right" width="50" valign="middle">' . $data['MaxQty'][$f] . '</td> <td align="right" width="50" valign="middle">' . $data['OrderQty'][$f] . '</td> <td align="right" width="60" valign="middle">' . $data['ActualQty'][$f] . '</td> <td align="left" width="100" valign="middle">' . $data['OUReason'][$f] . '</td> </tr>'; $f++; } $headertable = ''; while (@($row = mysql_fetch_array($result7))) { $headertable = '<tr> <td align="left" width="80" valign="middle"> ' . $gTEXT['Report Id'] . ' : ' . @$row['CFMStockId'] . '</td> <td align="left" width="220" valign="middle"> ' . $gTEXT['Created By'] . ' : ' . @$row['CreatedBy'] . '</td> <td align="left" width="220" valign="middle"> ' . $gTEXT['Last Upadated By'] . ' : ' . @$row['LastUpdateBy'] . '</td> <td align="left" width="220" valign="middle"> ' . $gTEXT['Submitted By'] . ' : ' . @$row['LastSubmittedBy'] . '</td> <td align="left" width="220" valign="middle"> ' . $gTEXT['Published By'] . ' : ' . @$row['PublishedBy'] . '</td> </tr> <tr> <td align="left" width="80" valign="middle"> <b style="font-size:11px;">' . @$row['StatusName'] . '</b></td> <td align="left" width="220" valign="middle"> ' . $gTEXT['Created Date'] . ' : ' . @$row['CreatedDt'] . '</td> <td align="left" width="220" valign="middle"> ' . $gTEXT['Last Updated Date'] . ' : ' . @$row['LastUpdateDt'] . '</td> <td align="left" width="220" valign="middle"> ' . $gTEXT['Submitted Date'] . ' : ' . @$row['LastSubmittedDt'] . '</td> <td align="left" width="220" valign="middle"> ' . $gTEXT['Published Date'] . ' : ' . @$row['PublishedDt'] . '</td> </tr>'; } $htmlHead = ' <style> td{ height: 6px; line-height:3px; } th{ height: 20; font-size:9px; } </style> <div style="margin:0 0 10px 0;"> <table width="100%" border="0.5" style="margin:0 auto;" class="clearfix"> ' . $headertable . ' </table> </div> <div class="clearfix"></div>'; $htmlC5 = ' <style> td{ height: 6px; line-height:3px; } th{ height: 20; font-size:9px; } </style> <div class="clearfix"></div> <div class="col-xs-12" style="font-weight:bold; font-size:14px; padding-left:6px; text-align:left;">' . $gTEXT['Stock Information'] . '</div> <table width="100%" border="0.5" style="margin:0 auto;"> <tr> <th align="center" width="30" valign="middle">' . $gTEXT['SL'] . '#</th> <th align="left" width="157" valign="middle">' . $gTEXT['Item'] . '</th> <th align="right" width="50" valign="middle">' . $gTEXT['OBL (A)'] . '</th> <th align="right" width="50" valign="middle">' . $gTEXT['Received (B)'] . '</th> <th align="right" width="50" valign="middle">' . $gTEXT['Dispensed (C)'] . '</th> <th align="right" width="50" valign="middle">' . $gTEXT['Adjusted (+-D)'] . '</th> <th align="left" width="55" valign="middle">' . $gTEXT['Adjust Reason'] . '</th> <th align="right" width="50" valign="middle">' . $gTEXT['Stock Out Days'] . '</th> <th align="left" width="55" valign="middle">' . $gTEXT['Stock Out Reason'] . '</th> <th align="right" width="50" valign="middle">' . $gTEXT['Closing Balance (E)'] . '</th> <th align="right" width="50" valign="middle">' . $gTEXT['AMC (F)'] . '</th> <th align="right" width="50" valign="middle">' . $gTEXT['MOS (G)'] . '</th> <th align="right" width="50" valign="middle">' . $gTEXT['Max Qty (H)'] . '</th> <th align="right" width="50" valign="middle">' . $gTEXT['Order Qty (I)'] . '</th> <th align="right" width="60" valign="middle">' . $gTEXT['Actual Order Qty (J)'] . '</th> <th align="left" width="100" valign="middle">' . $gTEXT['Order Qty Update Reason'] . '</th> </tr>' . $tblHTML . '</table>'; //echo $htmlC2; $pdf->SetFont('dejavusans', '', 7); $pdf->writeHTMLCell(0, 50, 10, 40, $htmlHead, '', 0, 0, false, 'C', true); $pdf->writeHTMLCell(0, 50, 10, 63, $htmlC1, '', 0, 0, false, 'C', true); $pdf->writeHTMLCell(0, 50, 63, 63, $htmlC2, '', 0, 0, false, 'C', true); //$pdf->writeHTMLCell(0, 50, 132, 60, $htmlC3, '', 0, 0, false, 'C', true); //$pdf->writeHTMLCell(0, 50, 208, 60, $htmlC4, '', 0, 0, false, 'C', true); $pdf->writeHTMLCell(0, 50, 10, 140, $htmlC5, '', 0, 0, false, 'C', true); //$pdf->writeHTMLCell(0, 50, 10, 290, $htmlC5, '', 0, 0, false, 'C', true); //$pdf->Cell(0, 0, $htmlC5, 1, 1, 'C'); $pdf->endPage(); $filename = 'Facility_Level_Patient_And_Stock_Status_' . $ItemGroupName . '_' . $MonthName . '_' . $Year . '.pdf'; $filePath = SITEDOCUMENT . 'administrator/components/com_jcode/source/report/pdfslice/' . $filename; if (file_exists($filePath)) { unlink($filePath); } $pdf->Output('pdfslice/' . $filename, 'F'); echo $filename; } else { echo 'Processing Error'; } }
header('Access-Control-Allow-Origin: *'); header('Access-Control-Allow-Methods: POST, GET, PUT, DELETE'); header('Content-type: application/json'); include_once 'Connect.php'; include_once 'UtilFunctions.php'; include_once 'class.phpmailer.php'; if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'DETAILS') { $User_ID = $_REQUEST['User_ID']; $query = "SELECT a.* \n\t\t\t\t\t\tFROM Clients a \n\t\t\t\t\t\tINNER JOIN Users u ON u.ID = a.User_ID \n\t\t\t\t\t\tWHERE u.User_ID = '" . $User_ID . "' \n\t\t\t\t\t\tLIMIT 1"; //echo $query;exit; $result = $mysqli->query($query); $consumer = array(); while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { //echo $row['ID']; $consumer[] = array('ID' => checkNull($row['ID'], ''), 'GivenName' => checkNull($row['GivenName'], ''), 'Surname' => checkNull($row['Surname'], ''), 'Email' => checkNull($row['Email'], ''), 'Phone' => checkNull($row['Phone'], ''), 'DOB' => checkNull($row['DOB'], ''), 'PostCode' => checkNull($row['PostCode'], '')); } getSuccessCreateResponse('', $consumer); } else { if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'UPD') { $userId = $_REQUEST['userID']; $Id = $_REQUEST['ID']; $GivenName = strtoupper($_REQUEST['GivenName']); $Surname = strtoupper($_REQUEST['Surname']); $DOB = $_REQUEST['DOB']; $PostCode = $_REQUEST['PostCode']; //$Email = strtoupper($_REQUEST['Email']); $Mobile = $_REQUEST['Mobile']; $Password = $_REQUEST['Password']; $query = "UPDATE `Clients` SET\n\t\t\t`GivenName` = '" . $GivenName . "' , \n\t\t\t`Surname` = '" . $Surname . "' , \n\t\t\t`DOB` = '" . $DOB . "' , \n\t\t\t`PostCode` = '" . $PostCode . "' ,\n\t\t\t`Last_Updated` = NOW() \t\n\t\tWHERE `ID` = " . $Id; $result = $mysqli->query($query);
foreach ($thing as &$row) { $row = str_getcsv($row, ";"); foreach ($row as &$deeper) { $cont = false; $deeper = str_getcsv($deeper); if (trim($deeper[0]) == "RECALL_NUMBER_NUM") { continue; //skip the headers } foreach ($rr as $a) { // Check for duplicates from new 60 day recalls if ($a['recall_number'] == $deeper[0]) { if (checkNull($a['year']) == $deeper[1]) { if (checkNull($a['manufacturer_recall_number']) == $deeper[2]) { if (checkNull($a['make']) == $deeper[5]) { if (checkNull($a['model']) == $deeper[6]) { //match found $cont = true; break; } } } } } } if ($cont == true) { continue; } $query = 'INSERT INTO recalls ( recall_number, year,
} } } else { if ($sortorder == "desc") { $filterquery .= " ORDER BY" . " " . $sortfield . " DESC LIMIT {$start}, {$pagesize}"; } else { if ($sortorder == "asc") { $filterquery .= " ORDER BY" . " " . $sortfield . " ASC LIMIT {$start}, {$pagesize}"; } } $query = $filterquery; } } } $result = $mysqli->query($query); $CPD_Articles = array(); // get data and store in a json array while ($row = mysqli_fetch_array($result, MYSQL_ASSOC)) { $CPD_Articles[] = array('ID' => checkNull($row['ID'], 0), 'Topic_ID' => checkNull($row['Topic_ID'], ''), 'Topic' => checkNull($row['Topic'], ''), 'Summary' => checkNull($row['Summary'], ''), 'CPD_ID' => checkNull($row['CPD_ID'], ''), 'CPD_Quiz' => checkNull($row['CPD_Quiz'], ''), 'PDF_File' => checkNull($row['PDF_File'], '')); } $data[] = array('TotalRows' => $total_rows, 'Rows' => $CPD_Articles); echo json_encode($data); } } } } } } } } $mysqli->close();
if ($sortorder != '') { if ($_GET['filterscount'] == 0) { if ($sortorder == "desc") { $query = "SELECT s.*, DOB as Birthdate,a.Description as Aim_Description, sp.Name as SP_Name, so.Description as SO_Description, s.Group_ID FROM Students s left join Aim a on a.ID = s.Aim left join SalesPerson sp on sp.ID = s.Salesperson left join Source so on so.ID = s.Source_id ORDER BY" . " " . $sortfield . " DESC LIMIT {$start}, {$pagesize}"; } else { if ($sortorder == "asc") { $query = "SELECT s.*, DOB as Birthdate,a.Description as Aim_Description, sp.Name as SP_Name, so.Description as SO_Description, s.Group_ID FROM Students s left join Aim a on a.ID = s.Aim left join SalesPerson sp on sp.ID = s.Salesperson left join Source so on so.ID = s.Source_id ORDER BY" . " " . $sortfield . " ASC LIMIT {$start}, {$pagesize}"; } } } else { if ($sortorder == "desc") { $filterquery .= " ORDER BY" . " " . $sortfield . " DESC LIMIT {$start}, {$pagesize}"; } else { if ($sortorder == "asc") { $filterquery .= " ORDER BY" . " " . $sortfield . " ASC LIMIT {$start}, {$pagesize}"; } } $query = $filterquery; } } } //echo $query; $result = $mysqli->query($query); $students = null; // get data and store in a json array while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { $students[] = array('StudentNo' => checkNull($row['StudentNo'], 0), 'GivenName' => checkNull($row['GivenName'], ''), 'Surname' => checkNull($row['Surname'], ''), 'Email' => checkNull($row['Email'], ''), 'Address' => checkNull($row['Address'], ''), 'PostCode' => checkNull($row['PostCode'], ''), 'MobilePhone' => checkNull($row['MobilePhone'], ''), 'WorkPhone' => checkNull($row['WorkPhone'], ''), 'HomePhone' => checkNull($row['HomePhone'], ''), 'Occupation' => checkNull($row['Occupation'], ''), 'Experience' => checkNull($row['Experience'], ''), 'Referrer' => checkNull($row['Referrer'], ''), 'Aim' => checkNull($row['Aim_Description'], ''), 'Source' => checkNull($row['SO_Description'], ''), 'Salesperson' => checkNull($row['SP_Name'], ''), 'Salesperson_ID' => checkNull($row['SalesPerson'], ''), 'Notes' => checkNull($row['Notes'], ''), 'Group' => $row['Group_ID'], 'Balance' => checkNull($row['Balance'], 0), 'DOB' => checkNull($row['Birthdate'], ''), 'Collections' => $row['Collectables']); } $data[] = array('TotalRows' => $total_rows, 'Rows' => $students); echo json_encode($data); $mysqli->close();
$query = "SELECT * from Instructor ORDER BY" . " " . $sortfield . " DESC LIMIT {$start}, {$pagesize}"; } else { if ($sortorder == "asc") { $query = "SELECT * from Instructor ORDER BY" . " " . $sortfield . " ASC LIMIT {$start}, {$pagesize}"; } } } else { if ($sortorder == "desc") { $filterquery .= " ORDER BY" . " " . $sortfield . " DESC LIMIT {$start}, {$pagesize}"; } else { if ($sortorder == "asc") { $filterquery .= " ORDER BY" . " " . $sortfield . " ASC LIMIT {$start}, {$pagesize}"; } } $query = $filterquery; } } } $result = mysql_query($query) or die("SQL Error 1: " . mysql_error()); $courses = null; // get data and store in a json array while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $courses[] = array('ID' => checkNull($row['ID'], 0), 'Name' => checkNull($row['Name'], '')); } $data[] = array('TotalRows' => $total_rows, 'Rows' => $courses); echo json_encode($data); } } } } }
$i = 1; while ($rec = mysql_fetch_array($r)) { echo '<tr> <td style="text-align: center; width: 50px;">' . $i . '</td> <td style="text-align: left; text-align: left; word-break:break-all; width: 210px;"> ' . $rec['ItemName'] . '</td> <td style="text-align: right;">' . checkNullable($rec['OpStock_A']) . '</td> <td style="text-align: right;">' . checkNullable($rec['ReceiveQty']) . '</td> <td style="text-align: right;">' . checkNullable($rec['DispenseQty']) . '</td> <td style="text-align: right;">' . checkNullable($rec['AdjustQty']) . '</td> <td style="text-align: left;">' . $rec['AdjustReason'] . '</td> <td style="text-align: right; word-break:break-all; width: 70px;">' . $rec['StockoutDays'] . '</td> <td style="text-align: left; word-break:break-all; width: 70px;">' . $rec['StockOutReasonName'] . '</td> <td style="text-align: right;">' . checkNullable($rec['ClStock_A']) . '</td> <td style="text-align: right;">' . checkNullable($rec['AMC']) . '</td> <td style="text-align: right;">' . checkNull(number_format($rec['MOS'], 1)) . '</td> <td style="text-align: right;">' . checkNullable($rec['MaxQty']) . '</td> <td style="text-align: right;">' . checkNullable($rec['OrderQty'] < 0 ? 0 : $rec['OrderQty']) . '</td> <td style="text-align: right;">' . checkNullable($rec['ActualQty'] < 0 ? 0 : $rec['ActualQty']) . '</td> <td style="text-align: left; text-align: left; word-break:break-all; width: 90px;">' . $rec['OUReason'] . '</td> </tr>'; $i++; } echo '</thead> </table> </div> </div> </div></div>'; echo '</body></html>'; } else { $error = "No record found";
public static function storeExportFile($original_filename, $file_content, $archiveFile = false, $dateShiftDates = false) { global $edoc_storage_option; ## Create the stored name of the file as it wll be stored in the file system $stored_name = date('YmdHis') . "_pid" . PROJECT_ID . "_" . generateRandomHash(6) . getFileExt($original_filename, true); $file_extension = getFileExt($original_filename); $mime_type = strtolower($file_extension) == 'csv' ? 'application/csv' : 'application/octet-stream'; // If file is UTF-8 encoded, then add BOM // Do NOT use addBOMtoUTF8() on Stata syntax file (.do) because BOM causes issues in syntax file if (strtolower($file_extension) != 'do') { $file_content = addBOMtoUTF8($file_content); } // If Gzip enabled, then gzip the file and append filename with .gz extension list($file_content, $stored_name, $gzipped) = gzip_encode_file($file_content, $stored_name); // Get file size in bytes $docs_size = strlen($file_content); // Add file to file system if ($edoc_storage_option == '0') { // Store locally $fp = fopen(EDOC_PATH . $stored_name, 'w'); if ($fp !== false && fwrite($fp, $file_content) !== false) { // Close connection fclose($fp); } else { // Send error response return false; } // Add file to S3 } elseif ($edoc_storage_option == '2') { global $amazon_s3_key, $amazon_s3_secret, $amazon_s3_bucket; $s3 = new S3($amazon_s3_key, $amazon_s3_secret, SSL); if (!$s3->putObject($file_content, $amazon_s3_bucket, $stored_name, S3::ACL_PUBLIC_READ_WRITE)) { // Send error response return false; } } else { // Store using WebDAV require_once APP_PATH_CLASSES . "WebdavClient.php"; require APP_PATH_WEBTOOLS . 'webdav/webdav_connection.php'; $wdc = new WebdavClient(); $wdc->set_server($webdav_hostname); $wdc->set_port($webdav_port); $wdc->set_ssl($webdav_ssl); $wdc->set_user($webdav_username); $wdc->set_pass($webdav_password); $wdc->set_protocol(1); // use HTTP/1.1 $wdc->set_debug(false); // enable debugging? if (!$wdc->open()) { // Send error response return false; } if (substr($webdav_path, -1) != '/') { $webdav_path .= '/'; } $http_status = $wdc->put($webdav_path . $stored_name, $file_content); $wdc->close(); } ## Add file info to edocs_metadata table // If not archiving file in File Repository, then set to be deleted in 1 hour $delete_time = $archiveFile ? "" : NOW; // Add to table $sql = "insert into redcap_edocs_metadata (stored_name, mime_type, doc_name, doc_size, file_extension, project_id, \n\t\t\t\tstored_date, delete_date, gzipped) values ('" . prep($stored_name) . "', '{$mime_type}', '" . prep($original_filename) . "', \n\t\t\t\t'" . prep($docs_size) . "', '" . prep($file_extension) . "', " . PROJECT_ID . ", '" . NOW . "', " . checkNull($delete_time) . ", {$gzipped})"; if (!db_query($sql)) { // Send error response return false; } // Get edoc_id $edoc_id = db_insert_id(); ## Add to doc_to_edoc table // Set flag if data is date shifted $dateShiftFlag = $dateShiftDates ? "DATE_SHIFT" : ""; // Set "comment" in docs table if (strtolower($file_extension) == 'csv') { $docs_comment = "Data export file created by " . USERID . " on " . date("Y-m-d-H-i-s"); } else { if ($file_extension == 'sps') { $stats_package_name = 'Spss'; } elseif ($file_extension == 'do') { $stats_package_name = 'Stata'; } else { $stats_package_name = camelCase($file_extension); } $docs_comment = "{$stats_package_name} syntax file created by " . USERID . " on " . date("Y-m-d-H-i-s"); } // Archive in redcap_docs table $sql = "INSERT INTO redcap_docs (project_id, docs_name, docs_file, docs_date, docs_size, docs_comment, docs_type, \n\t\t\t\tdocs_rights, export_file, temp) VALUES (" . PROJECT_ID . ", '" . prep($original_filename) . "', NULL, '" . TODAY . "', \n\t\t\t\t'{$docs_size}', '" . prep($docs_comment) . "', '{$mime_type}', " . checkNull($dateShiftFlag) . ", 1, \n\t\t\t\t" . checkNull($archiveFile ? "0" : "1") . ")"; if (db_query($sql)) { $docs_id = db_insert_id(); // Add to redcap_docs_to_edocs also $sql = "insert into redcap_docs_to_edocs (docs_id, doc_id) values ({$docs_id}, {$edoc_id})"; db_query($sql); } else { // Could not store in table, so remove from edocs_metadata also db_query("delete from redcap_edocs_metadata where doc_id = {$edoc_id}"); return false; } // Return successful response of docs_id from redcap_docs table return $docs_id; }
on duplicate key update query_status = " . checkNull($dr_status) . ", status_id = LAST_INSERT_ID(status_id)"; if ($debug) { show_var($sql, 'INSERT STATUS', 'red'); } if (true) { //if (db_query($sql)) { // Get cleaner_id $status_id = db_insert_id(); // Get current user's ui_id $userInitiator = User::getUserInfo(USERID); // Add new row to data_resolution_log $sql = "insert into redcap_data_quality_resolutions (status_id, ts, user_id, response_requested, response, comment, current_query_status, upload_doc_id) values ($status_id, '" . NOW . "', " . checkNull($userInitiator['ui_id']) . ", " . checkNull($response_requested) . ", " . checkNull($response) . ", " . checkNull($rule_info['name']) . ", " . checkNull($dr_status) . ", " . checkNull($_POST['upload_doc_id']) . ")"; if (!$debug) { if (db_query($sql)) { // Success, so return content via JSON to redisplay with new changes made $res_id = db_insert_id(); ## Logging // Set data values as json_encoded $logDataValues = json_encode(array('res_id' => $res_id, 'record' => $result['record'], 'event_id' => $result['event_id'], 'field' => $field, 'rule_id' => $rule_id)); // Set event_id in query string for logging purposes only $_GET['event_id'] = $result['event_id']; // Log it log_event($sql, "redcap_data_quality_resolutions", "MANAGE", $result['record'], $logDataValues, $drw_log); } else { // ERROR! exit('0');
<?php session_start(); include "top.php"; require 'model/database.php'; $title = $_POST["title"]; checkNull($title, "title"); $category = $_POST["category"]; $description = $_POST["description"]; if (isset($_POST['offer'])) { $offer = $_POST["offer"]; } else { checkNull(null, "offer"); } // echo"file 1:".$_FILES["file"]["name"][0]; // echo"file 2:".$_FILES["file"]["name"][1]; //print_r($_FILES); $imagesPathInDb = ""; $fileLoc = ""; $allowedExts = array("GIF", "JPEG", "JPG", "PNG"); for ($i = 0; $i < count($_FILES["file"]["name"]); $i++) { $currFileName = $_FILES["file"]["name"][$i]; $currFileTmpName = $_FILES["file"]["tmp_name"][$i]; $temp = explode(".", $currFileName); $extension = strtoupper(end($temp)); $currFileType = $_FILES["file"]["type"][$i]; $currFileError = $_FILES["file"]["error"][$i]; if (($currFileType == "image/gif" || $currFileType == "image/jpeg" || $currFileType == "image/jpg" || $currFileType == "image/pjpeg" || $currFileType == "image/x-png" || $currFileType == "image/png") && in_array($extension, $allowedExts)) { if ($currFileError > 0) { // echo "Return Code: " . $currFileError . "<br>"; } else {
$sortorder = $_GET['sortorder']; if ($sortorder != '') { if ($_GET['filterscount'] == 0) { if ($sortorder == "desc") { $query = $base_query . " " . $sortfield . " DESC LIMIT {$start}, {$pagesize}"; } else { if ($sortorder == "asc") { $query = $base_query . " " . $sortfield . " ASC LIMIT {$start}, {$pagesize}"; } } } else { if ($sortorder == "desc") { $filterquery .= " ORDER BY" . " " . $sortfield . " DESC LIMIT {$start}, {$pagesize}"; } else { if ($sortorder == "asc") { $filterquery .= " ORDER BY" . " " . $sortfield . " ASC LIMIT {$start}, {$pagesize}"; } } $query = $filterquery; } } } $result = $mysqli->query($query); $advisercpd = array(); // get data and store in a json array while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { $advisercpd[] = array('ID' => checkNull($row['ID'], 0), 'CPD_ID' => checkNull($row['CPD_ID'], ''), 'CPD_Name' => checkNull($row['Name'], ''), 'Points' => checkNull($row['Points'], ''), 'Certificate' => checkNull($row['Certificate'], ''), 'Result' => checkNull($row['Result'], ''), 'Date_Taken' => checkNull($row['Date_Taken'], '')); } $data[] = array('TotalRows' => $total_rows, 'Rows' => $advisercpd); echo json_encode($data); $mysqli->close();
/** * @param $sql * @param $table * @param $event * @param $record * @param $display * @param string $descrip * @param string $change_reason * @param $userid * @return bool|mysqli_result * * This function should only be used when required, to impersonate another user for the purpose of ensuring data integrity. * One example of this purpose is to replicate Survey respondent input so survey functionality is maintained. */ function target_proxy_log_event($sql, $table, $event, $record, $display, $descrip = "", $change_reason = "", $userid = "") { global $user_firstactivity, $rc_connection; // Pages that do not have authentication that should have USERID set to [non-user] $nonAuthPages = array("_cron/cirrhosis_reporting.php", "_cron/push-hcvrna-monitoring.php", "_cron/push_durations.php", "_cron/push_durations_to_repo.php", "_cron/push_svr_actual_to_pivot.php", "push_svr_actual_to_pivot.php", "_cron/update_daa.php"); // Log the event in the redcap_log_event table $ts = str_replace(array("-", ":", " "), array("", "", ""), NOW); $page = (defined("PAGE") ? PAGE : ""); $ip = (isset($userid) && $userid != "[Survey respondent]") ? "" : getIpAddress(); // Don't log IP for survey respondents $event = strtoupper($event); $event_id = (isset($_GET['event_id']) && is_numeric($_GET['event_id'])) ? $_GET['event_id'] : "NULL"; $project_id = defined("PROJECT_ID") ? PROJECT_ID : 0; // Query $sql = "INSERT INTO redcap_log_event (project_id, ts, user, ip, page, event, object_type, sql_log, pk, event_id, data_values, description, change_reason) VALUES ($project_id, $ts, '" . prep($userid) . "', " . checkNull($ip) . ", '$page', '$event', '$table', " . checkNull($sql) . ", " . checkNull($record) . ", $event_id, " . checkNull($display) . ", " . checkNull($descrip) . ", " . checkNull($change_reason) . ")"; $q = db_query($sql, $rc_connection); // FIRST/LAST ACTIVITY TIMESTAMP: Set timestamp of last activity (and first, if applicable) if (defined("USERID") && strpos(USERID, "[") === false) { // SET FIRST ACTIVITY TIMESTAMP: If this is the user's first activity to be logged in the log_event table, then log the time in the user_information table $sql_firstact = ""; if ((!isset($user_firstactivity) || (isset($user_firstactivity) && empty($user_firstactivity)))) { $sql_firstact = ", user_firstactivity = '" . NOW . "'"; } // SET LAST ACTIVITY TIMESTAMP $sql = "update redcap_user_information set user_lastactivity = '" . NOW . "' $sql_firstact where username = '******' limit 1"; db_query($sql, $rc_connection); } // Return true/false success for logged event return $q; }
print "\t\t\t</select>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td valign='top' style='font-size:11px;color:#666;padding-left:10px;'>\n\t\t\t\t\t\t\t{$lang['calendar_popup_24']} {$table_pk_label}\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t</tr></table>\n\t\t\t\t\t</td>\n\t\t\t\t</tr>"; } print "<tr>\n\t\t\t\t<td></td>\n\t\t\t\t<td valign='top'>\n\t\t\t\t\t<br><br>\n\t\t\t\t\t<input type='submit' value='{$lang['calendar_popup_25']}' onclick=\"\n\t\t\t\t\t\tif (document.getElementById('notes').value.length < 1) {\n\t\t\t\t\t\t\talert('{$lang['calendar_popup_26']}');\n\t\t\t\t\t\t\treturn false;\t\t\t\t\t\t\n\t\t\t\t\t\t}\n\t\t\t\t\t\">\n\t\t\t\t\t<br><br>\n\t\t\t\t</td>\n\t\t\t</tr>\n\t\t\t</table>\n\t\t\t</form>"; /** * DISPLAY CONFIRMATION THAT NEW CALENDAR EVENT WAS CREATED */ } elseif (!isset($_GET['cal_id']) && !empty($_POST)) { //If an existing record was selected, make sure record doesn't already exist in a DAG. If so, add its group_id to calendar event. if ($_POST['idnumber'] != "") { $group_id = db_result(db_query("select value from redcap_data where project_id = {$project_id} and record = '{$_POST['idnumber']}' and field_name = '__GROUPID__' limit 1"), 0); //If did not select a record, check if user is in DAG. } elseif ($user_rights['group_id'] != "") { $group_id = $user_rights['group_id']; } //Add event to calendar $sql = "insert into redcap_events_calendar (project_id, group_id, record, event_date, event_time, notes) values " . "({$project_id}, " . checkNull($group_id) . ", " . checkNull($_POST['idnumber']) . ", '{$_POST['event_date']}', " . checkNull($_POST['event_time']) . ", '" . prep($_POST['notes']) . "')"; //Success if (db_query($sql)) { //Logging log_event($sql, "redcap_events_calendar", "MANAGE", $new_cal_id, calLogChange(db_insert_id()), "Create calendar event"); //Show confirmation print "<div style='color:green;padding:30px 0 0 15px;margin-bottom:10px;font-weight:bold;font-size:16px;'>\n\t\t\t\t\t<img src='" . APP_PATH_IMAGES . "tick.png'>{$lang['calendar_popup_27']}<br><br><br>\n\t\t\t\t</div>"; //Render javascript to refresh calendar underneath and close pop-up print "<script type='text/javascript'>\n\t\t\t\twindow.opener.location.reload();\n\t\t\t\tsetTimeout(function(){self.close();},2500);\n\t\t\t\t</script>"; //Query failed } else { print "<p><b>{$lang['global_01']}{$lang['colon']}</b> {$lang['calendar_popup_28']}</p>"; if (SUPER_USER) { print db_error() . "<br>QUERY:<br>{$sql}"; } }
function uploadFinancialIndex($file, $fileMore) { // financial_index_all // line 1 : title列 公司代號 公司名稱 季別 ry // line 2 start : 公司data列 公司ID 公司名稱 季別 ry // 讀取兩個檔案 // 看哪個col數較多 設為file1 另一個為file2 $tempFile = loadCsvFile($file); $tempFile2 = loadCsvFile($fileMore); if ($tempFile && $tempFile2) { $tempFileRowArray = fgetcsv($tempFile); $tempFile2RowArray = fgetcsv($tempFile2); if (count($tempFileRowArray) > count($tempFile2RowArray)) { $file1 = $tempFile; $file2 = $tempFile2; } else { $file1 = $tempFile2; $file2 = $tempFile; } $fileRow = fgetcsv($file1); $file2Row = fgetcsv($file2); // 計算所需col index data[i]的i x file col數 // (1, 13) (3, 12) (4, 10) ... (8, 3) $colIndexArray = countFinancialIndex($fileRow, 1); $colIndexMoreArray = countFinancialIndex($file2Row, 2); // for each row // 儲存file1資料至data[] // while (file2 company_id < file1 company_id & file2 != null ) , file2 do fgetcsv // if (相同) 將file2中需要的資料儲存在data[] // else (file2 company_id > file1 company_id) 將data[]剩餘欄位設為null // 將data[]轉成字串sql // 上傳sql // loop until file1 無資料 $dataNum = 0; $mysql_command = ''; while ($file1Row = fgetcsv($file1)) { for ($i = 0; $i < count($colIndexArray); $i++) { $financialIndexData[$dataNum][$colIndexArray[$i][0]] = $file1Row[$colIndexArray[$i][1]]; } $season = convertDate2Season($financialIndexData[$dataNum][1]); // 檢查季別是否與使用者輸入的季別相同 // 若相同則繼續上傳動作 if (checkUploadSeason($season)) { while ($file2Row = fgetcsv($file2)) { if (trim($file2Row[0]) >= trim($financialIndexData[$dataNum][0])) { break; } } if (trim($file2Row[0]) === trim($financialIndexData[$dataNum][0])) { for ($i = 0; $i < count($colIndexMoreArray); $i++) { $financialIndexData[$dataNum][$colIndexMoreArray[$i][0]] = $file2Row[$colIndexMoreArray[$i][1]]; } } else { for ($i = 0; $i < count($colIndexMoreArray); $i++) { $financialIndexData[$dataNum][$colIndexMoreArray[$i][0]] = 'null'; } } $sql = ''; for ($i = 0; $i < count($financialIndexData[$dataNum]); $i++) { if ($sql != '') { $sql .= ', '; } if ($i === 1) { // season轉換格式 $sql .= convertDate2Season($financialIndexData[$dataNum][$i]); } else { $sql .= checkNull($financialIndexData[$dataNum][$i]); } } if ($mysqlCommand != '') { $mysqlCommand .= ', '; } $mysqlCommand .= '( ' . $sql . ')'; $dataNum++; } else { printError('檔案內的季別與輸入的上傳季別不一致 取消上傳動作'); } } $insertValue = '(`company_id`, `season`, `gross_margin`, `operating_income`, `pretax_income`, `ps_sales`, `ps_operating_income`, `ps_pre_tax_income`, `roe`, `roa`, `eps`, `current`, `acid_test`, `liabilities`, `times_interest_earne`, `aoverr_and_noverr_turnover`, `inventory_turnover`, `fixed_asset_turnover`, `total_asset_turnover`, `debt_over_equity_ratio`, `liabilities_to_assets_ratio`, `cashflow_operating`, `cashflow_investment`, `cashflow_financing`, `proceed_fm_newIssue`, `total_equity`, `lt_liabilities`, `total_fixed_assets`, `lt_investment`, `interest_exp`, `total_liabilities`, `net_sales`, `pre_tax_income`, `change_in_cashflow`) VALUES ' . $mysqlCommand . '<br>'; $GLOBALS['dbc_object']->insertData('financial_index_all', $insertValue); } }