<?php
include_once 'common/functions.php';
?>
<?php
$p = base64_decode($_REQUEST["p"]);
$update = "UPDATE lam_user_profile SET views = views+1 WHERE id = {$p}";
db_query($update);
$query = "SELECT * FROM lam_user_profile WHERE id = {$p} ORDER BY id DESC";
$data = db_fetch_item($query);
$images = explode(",", $data["pictures"]);
$i = 0;
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="description" content="">
<meta name="author" content="">
function get_images_info_by_temp_id($user_temp_id)
{
$sql = "select * from lu_user_image where user_temp_id = '" . $user_temp_id . "' limit 0,1";
$ImageData = db_fetch_item($sql);
return $ImageData;
}
/*--------------------------------------------------------------------------
* Data from DB
*------------------------------------------------------------------------*/
$cseq = $_GET['cseq'] == '' ? '' : $_GET['cseq'];
$id = $_GET['id'] == '' ? '' : $_GET['id'];
$sql = "select e.*,c.CR_CONT_CURR from " . $af_config['table']['estpublish'] . " e left join {$af_config['table']['cont']} c on e.CR_CONT_SEQ = c.CR_CONT_SEQ left join {$af_config['table']['customer']} u on c.CUST_COM_SEQ = u.CUST_COM_SEQ where e.CR_CONT_SEQ = '" . $cseq . "' and e.CR_ESTM_SEQ = " . $id;
$estinfo = db_fetch_item($sql);
if ($estinfo['CR_ESTM_SEQ'] == '') {
exit;
}
// EST 세부항목
$sql = "select * from " . $af_config['table']['esdlist'] . " where CR_CONT_SEQ = '" . $cseq . "' and CR_ESTM_SEQ = " . $id;
$esdlist = db_fetch($sql);
// 회사 및 PO 양식정보
$sql = "select * from " . $af_config['table']['company'] . " limit 1";
$company = db_fetch_item($sql);
//...print__r($company);
// 고객측 다운시
if (isset($_GET['cust']) && $_GET['cust'] == 1) {
$sql = "update " . $af_config['table']['estpublish'] . " set CR_ESTM_RCV = '" . $COMMON_CODE['C090']['02']['CODE_VAL'] . "', CR_ESTM_RCVDT=Now() where CR_CONT_SEQ='" . $cseq . "' and CR_ESTM_SEQ=" . $id;
db_query($sql);
}
$title = "견 적 서";
/*--------------------------------------------------------------------------
* PDF Template Include
*------------------------------------------------------------------------*/
$pdf_template = "./templates/est_template.php";
include_once $pdf_template;
/*--------------------------------------------------------------------------
* PDF 파일 생성
*------------------------------------------------------------------------*/
function getConfig()
{
global $af_config;
return db_fetch_item("select * from {$af_config['table']['config']} limit 1");
}
