입찰정보(키워드&수요기관) 목록으로 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); ?> ULOCA
수요기관 : ''   검색어 : ''
$row) { $bidClseDt[$key] = $row['bidClseDt']; } if (count($item)>1) array_multisort($bidClseDt, SORT_DESC, $item); // 마김일시 */ $i = 0; //foreach($item as $arr ) { //foreach element in $arr while ($arr = $result->fetch_assoc()) { //$uses = $item['var1']; //etc $k = $i + 1; $tr = ''; //$tr .= ''; $tr .= ''; $tr .= ''; $tr .= ''; if ($arr['presmptPrce'] == '') $tr .= ''; else $tr .= ''; $tr .= ''; $tr .= ''; $tr .= ''; $tr .= ''; /* if ($i % 2 == 0) { $tr = ''; $tr .= ''; $tr .= ''; $tr .= ''; $tr .= ''; $tr .= ''; $tr .= ''; $tr .= ''; } else { $tr = ""; $tr .= ''; $tr .= ''; $tr .= ''; $tr .= ''; $tr .= ''; $tr .= ''; $tr .= ''; } */ echo $tr; $i += 1; } echo '
번호 공고번호 공고명 추정가격 공고일시 마감일시 낙찰기업
' . $k . '' . $arr['bidNtceNo'] . '-' . $arr['bidNtceOrd'] . '' . $arr['bidNtceNm'] . '' . number_format($arr['presmptPrce']) . '' . substr($arr['bidNtceDt'], 0, 10) . '' . substr($arr['bidClseDt'], 0, 10) . '' . $arr['bidwinnrNm'] . '
'.$arr['bidNtceNo'].'-'.$arr['bidNtceOrd'].''.$arr['bidNtceNm'].''.number_format($arr['presmptPrce']).''.$arr['bidNtceDt'].''.$arr['bidClseDt'].'
'.$arr['bidNtceNo'].'-'.$arr['bidNtceOrd'].''.$arr['bidNtceNm'].''.number_format($arr['presmptPrce']).''.$arr['bidNtceDt'].''.$arr['bidClseDt'].'
'; ?>