public function login1($workNumber = "", $password = "", $tableName = "")
{
$con = mysql_connect("localhost", "root", "");
mysql_select_db('teacher_class_system', $con);
if (!$con) {
die('Could not connect: ' . mysql_error());
} else {
mysql_query("SET NAMES utf8");
$result = mysql_query("SELECT * FROM {$tableName} where workNumber = '{$workNumber}' and password = '******'");
if (mysql_num_rows($result) > 0) {
$result_arr = mysql_fetch_assoc($result);
$year = date("Y");
$date = date("Ymd");
$timeResult = mysql_query("SELECT * FROM task_info where year >= '{$year}'");
while ($row = mysql_fetch_array($timeResult)) {
$table_name = $row["relativeTable"];
if ($row["teacherDeadline"] < $date && $row["taskState"] == '0') {
$result1 = mysql_query("UPDATE `task_info` SET `taskState` = '1' where relativeTable='{$table_name}'");
}
if ($row["departmentDeadline"] < $date) {
$result1 = mysql_query("UPDATE task_info SET taskState = '2' where relativeTable='{$table_name}'");
}
}
mysql_close();
return json_encode_ex($result_arr, "");
} else {
mysql_close();
return "false";
}
}
}
public function queryTeacher($tableName = "", $workNumber = "", $ident = "")
{
$con = mysql_connect("localhost", "root", "");
mysql_select_db('teacher_class_system', $con);
if (!$con) {
die('Could not connect: ' . mysql_error());
} else {
mysql_query("SET NAMES utf8");
$state = mysql_query("SELECT taskState FROM task_info where relativeTable = {$tableName}");
$state_result = mysql_fetch_assoc($state);
if ($state_result['taskState'] > 1) {
$tableNameCB = 'cb_' . $tableName;
$statement = "SELECT * FROM {$tableNameCB}";
$result = mysql_query($statement);
while ($row = mysql_fetch_assoc($result)) {
$output[] = $row;
}
echo json_encode_ex($output, " ");
} else {
$result = mysql_query("SELECT * FROM {$tableName} WHERE workNumber = '{$workNumber}'");
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_assoc($result)) {
$output[] = $row;
}
echo json_encode_ex($output, " ");
} else {
$result = mysql_query("SELECT * FROM {$tableName} WHERE workNumber = ''");
while ($row = mysql_fetch_assoc($result)) {
$output[] = $row;
}
echo json_encode_ex($output, " ");
}
}
}
}
public function queryT($tableName = "")
{
$con = mysql_connect("localhost", "root", "");
mysql_select_db('teacher_class_system', $con);
if (!$con) {
die('Could not connect: ' . mysql_error());
} else {
mysql_query("SET NAMES utf8");
$result = mysql_query("SELECT * FROM {$tableName}");
while ($row = mysql_fetch_assoc($result)) {
$output[] = $row;
}
echo json_encode_ex($output, "");
mysql_close();
}
}
public function login1($workNumber = "", $password = "", $tableName = "")
{
$con = mysql_connect("localhost", "root", "");
mysql_select_db('teacher_class_system', $con);
if (!$con) {
die('Could not connect: ' . mysql_error());
} else {
mysql_query("SET NAMES utf8");
$result = mysql_query("SELECT * FROM {$tableName} where workNumber = {$workNumber} and password = {$password}");
if (mysql_num_rows($result) > 0) {
$result_arr = mysql_fetch_assoc($result);
mysql_close();
return json_encode_ex($result_arr, "");
} else {
mysql_close();
return "false";
}
}
}
/**
* 返回最新版本数据
* @return json
*/
public function version()
{
$appid = $this->input->get('appid');
$lang = $this->input->get('lang');
$lang = empty($lang) ? 0 : $lang;
// 默认为0
if (empty($appid)) {
$arr = array('result' => 1);
echo json_encode_ex($arr);
return;
}
$row = $this->export_model->get_versions_row_by_newest($appid);
if (is_null($row)) {
$arr = array('result' => 2);
echo json_encode_ex($arr);
return;
}
$base_url = $this->config->item('base_url');
$arr = array('result' => 0, 'code' => $row->code, 'version' => $row->version, 'url' => "{$base_url}{$this->app_path}/{$row->file_name}", 'file_size' => $row->file_size, 'compel' => $row->compel, 'context' => $lang == 0 ? $row->content_cn : $row->content_en);
echo json_encode_ex($arr);
}
<?
$viewingPage='terminal';
$overwriteTitle='Salamander Terminal';
$params=$node->page['params'];
header('Memory-Usage: '.memory_get_peak_usage(true));
header('DB-Count: '.$node->db->count);
if(count($params) && $params[0]==='command'){
//allow a request to suggest a template
/*if($node->user_user->currentId===false){
die('You are not logged in!');
}else*/if(isset($_POST['modal']) && isset($_POST['template'])){
$content=$node->render_haml->render($_POST['template'],$node->render_post->status,false,true);
$params=array('content'=>$content,
'id'=>$_POST['modalId'],
'title'=>$_POST['modalTitle']);
die($node->render_haml->render($appDir.'/blocks/modal',$params,false,true));
}elseif(isset($_POST['template']))
die($node->render_haml->render($_POST['template'],$node->render_post->status,false,true));
//or send json data
elseif(is_array($node->render_post->status))
die(json_encode_ex($node->render_post->status));
//or just send the string
else die($node->render_post->status);
}
public function post_menu()
{
//构造自定义菜单数据
$WxMenu = M('WxMenu');
$mu_map = array();
$mu_map['p_id'] = array('eq', 0);
$mu_map['is_show'] = array('eq', 1);
$list = $WxMenu->where($mu_map)->order('sort asc')->select();
$post_arr = array();
$post_sub_arr = array();
if (is_array($list) && !empty($list)) {
foreach ($list as $key => $v) {
if ($v['name']) {
$post_arr['button'][$key]['name'] = $v['name'];
$sub_mu = array();
$sub_mu['p_id'] = array('eq', $v['id']);
$sub_mu['is_show'] = array('eq', 1);
$sub_list = $WxMenu->where($sub_mu)->order('sort asc')->field('type,name,key_url')->select();
$sb = array();
if (is_array($sub_list) && !empty($sub_list)) {
foreach ($sub_list as $k => $sb) {
if ($sb['name']) {
$post_sub_arr[$k]['type'] = $sb['type'];
$post_sub_arr[$k]['name'] = $sb['name'];
if ($sb['type'] == 'view') {
$post_sub_arr[$k]['url'] = $sb['key_url'];
} else {
$post_sub_arr[$k]['key'] = $sb['key_url'];
}
}
}
} else {
$post_arr['button'][$key]['type'] = $v['type'];
if ($v['type'] == 'view') {
$post_arr['button'][$key]['url'] = $v['key_url'];
} else {
$post_arr['button'][$key]['key'] = $v['key_url'];
}
}
if (!empty($post_sub_arr)) {
$post_arr['button'][$key]['sub_button'] = $post_sub_arr;
}
unset($post_sub_arr);
}
}
}
//$post_data = json_encode($post_arr,JSON_UNESCAPED_UNICODE); //防中文转义
$post_data = json_encode_ex($post_arr);
$post_data = str_replace("\\/", "/", $post_data);
$wx_ACCESS_TOKEN = get_wx_AccessToken(1);
$url = 'https://api.weixin.qq.com/cgi-bin/menu/create?access_token=' . $wx_ACCESS_TOKEN;
$return = post_url($url, $post_data);
if ($return) {
$this->success('操作成功', U('Weixin/wx_menu'));
exit;
}
}
