}
//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) {
