<?php
$post_val
=
file_get_contents
(
'php://input'
);//jq ajax的json数据用此方法接收
$post_str
=json_decode(
$post_val
, true);
$action
=
$post_str
[
'action'
];
$zc_code
=
$post_str
[
'zc_code'
];
if
(
$action
==
'get'
){
if
(
strpos
(
$zc_code
,
"-"
)===false){
echo
'{"back_status":"error","back_message":"资产编码格式错误,请完整输入!"}'
;
exit
;
}
$biaoji
=
explode
(
'-'
,
$zc_code
);
if
(
$biaoji
[0]==
'FGZ'
){
$select_table
=
'dangxiao_zichan_guzi_1'
;
$select_pm_table
=
'dangxiao_zichan_fenlei'
;
}
elseif
(
$biaoji
[0]==
'GZ'
){
$select_table
=
'dangxiao_zichan_guzi_2'
;
$select_pm_table
=
'dangxiao_zichan_fenlei_guzi'
;
}
if
(
$biaoji
[0]==
'GZ'
||
$biaoji
[0]==
'FGZ'
){
$sql_2
=
"select id,pinming,guige from "
.
$select_table
.
" where zhangtao='"
.
$_SESSION
['dangxiao_zc_zhangtao
']."'
and
id=
'".$biaoji[1]."'
limit 1 ";
$result_2
=
$mysqli
->query(
$sql_2
);
if
(
$rs_2
=
$result_2
->fetch_assoc()){
$guige
=
$rs_2
[
"guige"
];
$id
=
$rs_2
[
"id"
];
$pinming
=
$rs_2
[
"pinming"
];
$sql_1
=
"select biaoqian from "
.
$select_pm_table
.
" where zhangtao='"
.
$_SESSION
['dangxiao_zc_zhangtao
']."'
and
id=
'".$pinming."'
limit 1 ";
$result_1
=
$mysqli
->query(
$sql_1
);
if
(
$rs_1
=
$result_1
->fetch_assoc()){
$biaoqian
=
$rs_1
[
"biaoqian"
];
}
echo
'{"back_status":"ok","zc_code":"'
.
$zc_code
.
'","pinming":"'
.
$biaoqian
.
'","guige":"'
.
$guige
.
'"}'
;
exit
;
}
else
{
echo
'{"back_status":"error","back_message":"资产编号【'
.
$zc_code
.
'】不存在,请核对!"}'
;
exit
;
}
}
if
(
$biaoji
[0]==
'QT'
){
$sql_2
=
"select id,guige,danwei_wz,biaoqian from dangxiao_zichan_fenlei_qita where zhangtao='"
.
$_SESSION
['dangxiao_zc_zhangtao
']."'
and
id=
'".$biaoji[1]."'
limit 1 ";
$result_2
=
$mysqli
->query(
$sql_2
);
if
(
$rs_2
=
$result_2
->fetch_assoc()){
$guige
=
$rs_2
[
"guige"
];
$id
=
$rs_2
[
"id"
];
$biaoqian
=
$rs_2
[
"biaoqian"
];
echo
'{"back_status":"ok","zc_code":"'
.
$zc_code
.
'","pinming":"'
.
$biaoqian
.
'","guige":"'
.
$guige
.
'"}'
;
exit
;
}
else
{
echo
'{"back_status":"error","back_message":"资产编号【'
.
$zc_code
.
'】不存在,请核对!"}'
;
exit
;
}
}
}
?>
$json_arr
=
array
(
'back_status'
=>
'ok'
,
'shidu'
=>
$shidu_str
,
'wendu'
=>iconv(
'gbk'
,
'utf-8'
,
$wendu_str
),
'message'
=>
$get_value
);
echo
json_encode(
$json_arr
);