/*
입찰정보(수요기관 링크)==>입찰정보(키워드&수요기관) 목록으로 2018/07/10
2018-07-10 1년간 키워드&수요기관 검색 api
2018-11-30 2016년 부터 키워드&수요기관 검색 db openBidInfo 키워드 kwd=bidNtceNm 수요기관=dminsttNm
*/
@extract($_GET);
@extract($_POST);
@extract($_SERVER);
session_start();
require($_SERVER['DOCUMENT_ROOT'] . '/classphp/g2bClass.php'); //'/g2b/classPHP/g2bClass.php');
$g2bClass = new g2bClass;
$mobile = $g2bClass->MobileCheck(); // "Mobile" : "Computer"
require($_SERVER['DOCUMENT_ROOT'] . '/classphp/dbConn.php');
$dbConn = new dbConnClass;
$conn = $dbConn->conn();
// --------------------------------- log
$rmrk = '';
$dbConn->logWrite($_SESSION['current_user']->user_login, $_SERVER['REQUEST_URI'], $rmrk);
// --------------------------------- log
function rs2Json11($stmt, $colArray)
{
$json_string = '{"response": { "header": { "resultCode": "00", "resultMsg":"정상"}, "body": { "items": [';
$rowCount = $stmt->num_rows;
$colcnt = count($colArray);
$i = 1;
while ($row = $g2bClass->fetchRowAssoc($stmt, $colArray)) { //while ($row = $result->fetch_assoc()) {
//echo $i;
$json_string .= '{ ';
foreach ($row as $key => $value) {
$json_string .= '"' . $key . '": "' . $value . '", ';
}
$json_string = substr($json_string, 0, strlen($json_string) - 2);
if ($i > $rowCount - 1) $json_string .= '}';
else $json_string .= '},';
$i++;
}
$json_string .= '], "numOfRows": ' . $rowCount . ', "pageNo": 1, "totalCount": ' . $rowCount . '}} }'; // $json1['response']['body']['totalCount']. '}} }';
return $json_string;
//$i += 1;
}
//$kwd = ''; // 검색어 없앰........... 2018/7/9 다시 살림 11/28
$bidrdo = '';
$pss = ""; // 3개 한꺼번에
$sYear = '';
$LikeOrEqual = 'equal';
$startNo = 0;
$noOfRow = 1000;
$result = $dbConn->getSvrDataDB2_mysqli($conn, $bidrdo, $kwd, $dminsttNm, $pss, $sYear, $LikeOrEqual, $startNo, $noOfRow);
//$rowCount = $stmt->num_rows;
// $fields = bindAll2($stmt);
// $json_string = rs2Json11($stmt, $fields);
// echo ($json_string);
/*$response1 = $g2bClass->getSvrData('bidthing',$inqryBgnDt,$inqryEndDt,$kwd,$dminsttNm,'300','1','1'); // 물품입찰
$response2 = $g2bClass->getSvrData('bidcnstwk',$inqryBgnDt,$inqryEndDt,$kwd,$dminsttNm,'300','1','1'); // 공사입찰
$response3 = $g2bClass->getSvrData('bidservc',$inqryBgnDt,$inqryEndDt,$kwd,$dminsttNm,'300','1','1'); // 용역입찰
//$response4 = $g2bClass->getSvrData('scsbidfrgcpt',$inqryBgnDt,$inqryEndDt,$kwd,$dminsttNm,'100','1','1'); // 외자입찰
$json1 = json_decode($response1, true);
$item1 = $json1['response']['body']['items'];
//echo '
'.'물품입찰
';
//var_dump($response1);
$json2 = json_decode($response2, true);
$item2 = $json2['response']['body']['items'];
$json3 = json_decode($response3, true);
*/
//var_dump($json_string);
//$item = $json_string['response']['body']['items'];
//$item = array_merge($item1,$item2,$item3); //,$item4);
//var_dump($response);
?>
번호 | 공고번호 | 공고명 | 추정가격 | 공고일시 | 마감일시 | 낙찰기업 | ||
---|---|---|---|---|---|---|---|---|
'; $tr .= ' | ' . $k . ' | '; $tr .= '' . $arr['bidNtceNo'] . '-' . $arr['bidNtceOrd'] . ' | '; $tr .= '' . $arr['bidNtceNm'] . ' | '; if ($arr['presmptPrce'] == '') $tr .= ''; else $tr .= ' | ' . number_format($arr['presmptPrce']) . ' | '; $tr .= '' . substr($arr['bidNtceDt'], 0, 10) . ' | '; $tr .= '' . substr($arr['bidClseDt'], 0, 10) . ' | '; $tr .= '' . $arr['bidwinnrNm'] . ' | '; $tr .= '
'; $tr .= ' | '.$arr['bidNtceNo'].'-'.$arr['bidNtceOrd'].' | '; $tr .= ''.$arr['bidNtceNm'].' | '; $tr .= ''.number_format($arr['presmptPrce']).' | '; $tr .= ''.$arr['bidNtceDt'].' | '; $tr .= ''.$arr['bidClseDt'].' | '; $tr .= '|||
'; $tr .= ' | '.$arr['bidNtceNo'].'-'.$arr['bidNtceOrd'].' | '; $tr .= ''.$arr['bidNtceNm'].' | '; $tr .= ''.number_format($arr['presmptPrce']).' | '; $tr .= ''.$arr['bidNtceDt'].' | '; $tr .= ''.$arr['bidClseDt'].' | '; $tr .= '