} //INSERT RECORDS (table with primary keys) $table_array = array('m_consult', 'm_patient_mc', 'm_patient_fp', 'm_patient_ccdev', 'm_consult_notes', 'm_patient_fp_method_service', 'm_patient_fp_dropout', 'm_family', 'm_consult_lab', 'm_patient_ntp', 'm_family_cct_member', 'm_consult_ntp_symptopmatics', 'm_patient_ntp_report', 'm_consult_reminder', 'm_patient_fp_method', 'm_consult_appointments'); //schedule_id //list of secondary table with foreign key foreach ($table_array as $tablename) { lite_connect($_POST['sync_user']); $check_status_sql = "SELECT lite_patient_id, emr_patient_id, lite_specific_id, emr_specific_id, table_name, entry_date, sync_type FROM m_push_status WHERE push_flag ='Y' AND table_name='{$tablename}' AND sync_type='N'"; $new_consult_array = get_data_array($check_status_sql); //print_r($new_consult_array); if ($new_consult_array != NULL || $new_consult_array != '') { ehr_connect(); $array_m_push_update = array(); foreach ($new_consult_array as $c_array => $new_consult) { $new_id = 0; $new_id = get_new_id($new_consult); $insert_text = insert_values($new_consult, $new_id); if ($new_consult[4] == 'm_patient_fp_method_service') { lite_connect($_POST['sync_user']); $where_clause = "fp_px_id = '{$new_consult['2']}' AND patient_id = '{$new_consult['0']}'"; $get_all = mysql_query("SELECT * FROM {$new_consult['4']} WHERE {$where_clause}") or die("Error 93 : " . mysql_error()); //echo "CHECK QUERY : SELECT * FROM $new_consult[4] WHERE $where_clause <br /><br />"; while ($get_all_result = mysql_fetch_array($get_all)) { //echo "<br />".$get_all_result[date_service]."<br />"; $where_clause = "fp_id = '{$new_consult['8']}' AND fp_px_id = '{$new_consult['9']}' AND patient_id = '{$new_consult['10']}' AND consult_id = '{$new_consult['11']}' AND date_service = '{$get_all_result['date_service']}'"; //echo "<br />SELECT * FROM $new_consult[4] WHERE $where_clause<br />"; ehr_connect(); $check_consult_exist_sql = mysql_query("SELECT * FROM {$new_consult['4']} WHERE {$where_clause}") or die("Error 92 : " . mysql_error()); if (mysql_num_rows($check_consult_exist_sql) == 0) { $get_latest_id = mysql_query("SELECT fp_service_id FROM m_patient_fp_method_service ORDER BY fp_service_id DESC LIMIT 1") or die("Error 77 : " . mysql_error()); $get_latest_id_result = mysql_fetch_array($get_latest_id);
unset($array_m_push_update); } else { echo "No new consult"; } //other table with consult_id $table_array = array('m_patient_mc', 'm_patient_fp'); //list of secondary table related with consult_id foreach ($table_array as $tablename) { lite_connect($host); $check_status_sql = "SELECT lite_patient_id, emr_patient_id, lite_specific_id, emr_specific_id, table_name, entry_date, sync_type FROM m_push_status WHERE push_flag ='Y' AND table_name='{$tablename}' AND sync_type='N'"; $new_entry_array = get_data_array($check_status_sql); if ($new_entry_array != NULL || $new_consult_array != '') { ehr_connect(); $array_m_push_update = array(); foreach ($new_entry_array as $entry_array => $new_entry) { $new_id = get_new_id($new_entry); $insert_text = insert_values($new_entry, $new_id); insert_query($insert_text, $new_entry[4]); $push_data_array = array($new_entry[0], $new_entry[1], $new_entry[2], $new_id, $new_entry[4], $new_entry[5], 'N', $new_entry[6]); array_push($array_m_push_update, $push_data_array); unset($push_data_array); } update_m_push($array_m_push_update, 'new'); unset($array_m_push_update); } } function insert_query() { if (func_num_args() > 0) { $arg_list = func_get_args(); $list = $arg_list[0];
} function insert_abstract($dbc, $abstract, $article_id) { $query = "SELECT MAX(id) as id FROM `tcmks`.`segment`"; $result = mysqli_query($dbc, $query) or die('Error querying database1.'); $row = mysqli_fetch_array($result); $id = $row['id'] + 1; $user_id = $_SESSION['id']; $query = "INSERT INTO segment (id, title, content, rank, user_id) " . "VALUES ('{$id}','摘要','" . mysql_escape_string($abstract) . "', '1','{$user_id}')"; mysqli_query($dbc, $query) or die('Error querying database2.'); return $id; } if (isset($_POST['submit'])) { $title = $_POST['title']; $abstract = $_POST['abstract']; $id = get_new_id($dbc); $query = "INSERT INTO article (id, title) " . "VALUES ('{$id}','" . mysql_escape_string($title) . "')"; mysqli_query($dbc, $query) or die('Error querying database:'); $segment_id = insert_abstract($dbc, $abstract, $id); $query = "UPDATE article SET segments = '|{$segment_id}|' where id = '{$id}'"; mysqli_query($dbc, $query) or die('Error querying database5.'); $creator = $_SESSION['id']; $query = "INSERT INTO authorship (article_id, author_id, role) " . "VALUES ('{$id}','{$creator}', 'creator')"; mysqli_query($dbc, $query) or die('Error querying database:'); echo '<div class="alert alert-success">'; echo '<button type="button" class="close" data-dismiss="alert">×</button>'; echo '<h4>综述文献' . $title . '创建成功!</h4>'; echo '<p>' . $abstract . '</p>'; echo '<a href="article.php?id=' . $id . '">查看并编辑</a>'; echo '</div>'; }
case 14: check_authorization(); remove_spellset(); header("Location: index.php?editor=spellset&z={$z}&zoneid={$zoneid}&npcid={$npcid}"); exit; case 15: // Search spells $body = new Template("templates/spellset/spell.searchresults.tmpl.php"); $results = search_spells(); $body->set("results", $results); break; case 16: // Copy spellset check_authorization(); copy_spellset(); $nss = get_new_id(); header("Location: index.php?editor=spellset&z={$z}&zoneid={$zoneid}&npcid={$npcid}"); exit; case 17: // Mass change spellset check_authorization(); $body = new Template("templates/spellset/spellset.masschange.tmpl.php"); $body->set('currzone', $z); $body->set('currzoneid', $zoneid); $body->set('npcid', $npcid); $body->set('id', $_GET['id']); break; case 18: check_authorization(); $body = new Template("templates/spellset/spellset.changebyname.tmpl.php"); $body->set('currzone', $z);
$body->set("tradeskills", $tradeskills); if ($_GET['ts'] > 0) { $body->set('ts', $_GET['ts']); } break; case 11: // Add component check_authorization(); $id = add_recipe(); header("Location: index.php?editor=tradeskill&rec={$id}"); exit; case 12: // Copy tradeskill check_authorization(); copy_tradeskill(); $nrec = get_new_id(); header("Location: index.php?editor=tradeskill&ts={$ts}&rec={$nrec}"); exit; case 13: // View Learned Recipes check_authorization(); $breadcrumbs .= " >> Learned Recipes"; $curr_page = isset($_GET['page']) ? $_GET['page'] : $default_page; $curr_size = isset($_GET['size']) ? $_GET['size'] : $default_size; $curr_sort = isset($_GET['sort']) ? $columns[$_GET['sort']] : $columns[$default_sort]; $body = new Template("templates/tradeskill/learned.tmpl.php"); $page_stats = getPageInfo("char_recipe_list", $curr_page, $curr_size, $_GET['sort']); if ($page_stats['page']) { $recipes = getLearnedRecipes($page_stats['page'], $curr_size, $curr_sort); } if ($recipes) {