|
Server : Apache/2.2.2 (Fedora) System : Linux App1.pathumtani.go.th 2.6.20-1.2320.fc5smp #1 SMP Tue Jun 12 19:40:16 EDT 2007 i686 User : apache ( 48) PHP Version : 5.2.9 Disable Function : NONE Directory : /home/pathumthani_integration/integration/application/pauper_surway/ |
Upload File : |
<style type="text/css">
<!--
.style2 {color: #FF0000}
-->
</style>
<SCRIPT LANGUAGE="JavaScript">
var xmlHttp;
function createXMLHttpRequest() {
if (window.ActiveXObject) {
xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
}
else if (window.XMLHttpRequest) {
xmlHttp = new XMLHttpRequest();
}
}
function handleStateChange() {
if(xmlHttp.readyState == 4) {
if(xmlHttp.status == 200) {
updateproductList();
}
}
}
function updateproductList() {
clearproductList();
var department = document.getElementById("alleg_department");
var results = xmlHttp.responseText;
var option = null;
p=results.split(",");
option = document.createElement("option");
option.setAttribute("value",0);
option.appendChild(document.createTextNode("ไม่ระบุ"));
department.appendChild(option);
for (var i = 0; i < p.length; i++){
if(p[i] > ""){
x = p[i].split("::");
option = document.createElement("option");
option.setAttribute("value",x[1]);
option.appendChild(document.createTextNode(x[0]));
department.appendChild(option);
}
}
}
function clearproductList() {
var department = document.getElementById("alleg_department");
while(department.childNodes.length > 0) {
department.removeChild(department.childNodes[0]);
}
}
function refreshproductList() {
var ministry = document.getElementById("alleg_ministry").value;
if(ministry == "" ) {
clearproductList();
return;
}
var url = "ajax_minitry.php?ministry_id=" + ministry;
createXMLHttpRequest();
xmlHttp.onreadystatechange = handleStateChange;
xmlHttp.open("GET", url, true);
xmlHttp.send(null);
}
function ShowAmphur(name,value){
var obj = window.document.getElementsByName(name)[0];
if (obj){
obj.value = value;
}
}
var gFiles = 0;
function addforpay() {
var subS = "คำอธิบายไฟล์ : ";
var subS1 = " ไฟล์แนบ : ";
var li = document.createElement('li');
li.setAttribute('id', 'file_debt-' + gFiles);
li.innerHTML ='<input type="text" name="pay_sub[]" size="30">'+'<input type="text" name="money_debt_ex_sub[]" id="money_debt_ex_sub" size="10" >'+'<input type="text" name="time_debt_sub[]" id="time_debt_sub" size="10" >'+'<input type="text" name="interrest_sub[]" id="interrest_sub" size="10" >'+'<input type="text" name="money_debt_sub[]" id="money_debt_sub" size="10" >'+'<select name="per_date_sub[]" id="per_date_sub"><option>เลือก</option><option value="วัน">วัน</option><option value="เดือน">เดือน</option><option value="ปี">ปี</option></select>'+' <select name="pay_for_sub[]" id="pay_for_sub"><option>เลือก</option><option value="ปกติ">ปกติ</option><option value="ไม่ปกติ">ไม่ปกติ</option><option value="หยุด">หยุด</option></select>'+'<input type="text" name="rent_for_sub[]" id="rent_for[]" /><span onclick="removeFile8(\'file_debt-' + gFiles + '\')" style="cursor:pointer;"> <img src=images/icon.minus.dim.gif border="0" width="18" height="12"></span>';
document.getElementById('files-rootpay').appendChild(li);
gFiles++;
}
/*'+' <select name="per_date[]" id="per_date[]">
<option>เลือก</option>
<option value="วัน">วัน</option>
<option value="เดือน">เดือน</option>
<option value="ปี">ปี</option>
</select>'+' <select name="pay_for[]" id="pay_for[]">
<option selected="selected">เลือก</option>
<option value="ปกติ">ปกติ</option>
<option value="ไม่ปกติ">ไม่ปกติ</option>
<option value="หยุด">หยุด</option>
</select>*/
function removeFile8(aId8,e){
var obj = document.getElementById(aId8);
obj.parentNode.removeChild(obj);
var temp8 = document.getElementById('note_fileTEMP8');
temp8.value=temp8.value+':'+e;
//alert(temp.value);
}
/// function check เลขบัตร
function checkID(id) {
if(id.length != 13) return false;
for(i=0, sum=0; i < 12; i++)
sum += parseFloat(id.charAt(i))*(13-i);
if((11-sum%11)%10!=parseFloat(id.charAt(12))) return false;
return true;
}
// end function check เลขบัตร
function CheckForm(){
var type_u = document.getElementById("type_user").value;
// alert (document.form.type_problem.value);
if(document.form.type_problem.value == "6"){
if(document.form.problem_comment.value == ""){
alert(" ! กรุณาระบุรายละเอียดเรื่องร้องเรียน ");
document.form.problem_comment.focus();
return false;
}
}
if(document.form.type_process.value == "5"){
if(document.form.process_comment.value == ""){
alert(" ! กรุณาระบุรายละเอียดการดำเนินการที่ต้องการ ");
document.form.process_comment.focus();
return false;
}
}
if(document.form.public_name.value == ""){
alert(" !กรุณาระบุชื่อ - สกุล ผู้ถูกร้องเรียน");
document.form.public_name.focus();
return false;
}else if(document.form.type_problem.value == ""){
alert(" !กรุณาระบุประเภทเรื่องร้องเรียน ");
document.form.type_problem.focus();
return false;
}else if(document.form.complain_detail.value == ""){
alert(" !กรุณาระบุข้อกล่าวหา / ข้อร้องเรียน");
document.form.complain_detail.focus();
return false;
}else if(document.form.type_process.value == ""){
alert(" !กรุณาระบุประเภทดำเนินการ ");
document.form.type_process.focus();
return false;
}else{
if(type_u != "gov"){
if(document.form.public_name.value == ""){
alert(" ! กรุณาระบุชื่อของท่านด้วยครับ");
document.form.public_name.focus();
return false;
}else if(!checkID(document.form.public_idcard.value)){
alert(" ! เลขบัตรประจำตัวของท่านไม่ถูกต้องตามกรมการปกครอง กรุณาระบุใหม่อีกครั้ง");
document.form.public_idcard.focus();
return false;
}else if(document.form.char_code.value == ""){
alert(" !กรุณาระบุรหัสภาพ");
document.form.char_code.focus();
return false;
}
}else{
return true;
}
}
}
</SCRIPT>
<script>
<!--
function checkQuantity(MyID, maxValue){
var q = document.getElementById(MyID);
if(parseInt(q.value)>maxValue){
alert("กรุณาตรวจสอบตัวเลขที่กรอก\nตัวเลขอาจเกินกว่าความเป็นจริง");
}
}
function open_win(win_file, win_title)
{
window.open(win_file, win_title, 'resizable=yes,width=900,height=500,toolbar=no,scrollbars=yes,location=no,menubar=no,status=no');
}
-->
</script>
<SCRIPT language="javascript1.2">
function CreateXmlHttp(){
//Creating object of XMLHTTP in IE
try {
XmlHttp = new ActiveXObject("Msxml2.XMLHTTP");
}
catch(e){
try{
XmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
}
catch(oc) {
XmlHttp = null;
}
}
//Creating object of XMLHTTP in Mozilla and Safari
if(!XmlHttp && typeof XMLHttpRequest != "undefined") {
XmlHttp = new XMLHttpRequest();
}
} // end function CreateXmlHttp
<? if ( $objMB->addr_province && $objMB->addr_amphur && $objMB->addr_tambon ) echo "chgAmphur('$objMB->addr_province', '$objMB->addr_amphur', '$objMB->addr_tambon');"; ?>
function addforpay(){
var code_id=document.getElementById('code_id1');
var name=document.getElementById('name1');
var lastname=document.getElementById('lastname1');
var status = document.getElementById('status');
var age = document.getElementById('age1');
var sex1 = document.getElementById('sex1');
var sex2 = document.getElementById('sex2');
var education = document.getElementById('education');
/*var career = document.getElementById('career');
var salary = document.getElementById('salary1');
var pay = document.getElementById('pay1');
var sick = document.getElementById('sick1');
var gimp = document.getElementById('gimp1');
var old = document.getElementById('old1');
var spacial = document.getElementById('spacial1');*/
//alert(code_id.value);
var newCell = document.getElementById('TBL_INSERT');
var numRow = newCell.rows.length;
var insetTB = newCell.insertRow(numRow);
//alert(numRow);
var td1 = insetTB.insertCell(0);
var td2 = insetTB.insertCell(1);
var td3 = insetTB.insertCell(2);
var td4 = insetTB.insertCell(3);
var td5 = insetTB.insertCell(4);
var td6 = insetTB.insertCell(5);
var td7 = insetTB.insertCell(6);
var td8 = insetTB.insertCell(7);
// var td9 = insetTB.insertCell(8);
// var td10 = insetTB.insertCell(9);
// var td11 = insetTB.insertCell(10);
// var td12 = insetTB.insertCell(11);
// var td13 = insetTB.insertCell(12);
// var td14 = insetTB.insertCell(13);
//var arrText = varText.split(":");
//Text Field
text_field1 ='<input type="hidden" name="type_debt_sub[]" id="type_debt_sub[]" value="สินค้าเงินผ่อน"/>'+'<input type="" name="name_debt_sub[]" id="name_debt_sub[]" value="" />'+'<input type="hidden" name="num_sub[]" id="num_sub" size="5"/>';
text_field2 = ' <input type="text" name="money_debt_ex_sub[]" id="money_debt_ex_sub" size="10" />';
text_field3 =' <input type="text" name="time_debt_sub[]" id="time_debt_sub" size="10" />';
text_field4='<input type="text" name="interrest_sub[]" id="interrest_sub" size="10" />';
text_field5 ='<input type="text" name="money_debt_sub[]" id="money_debt_sub" size="10" />';
text_field6 = '<select name="per_date_sub[]" id="per_date_sub"><option>เลือก</option><option value="วัน">วัน</option> <option value="เดือน">เดือน</option><option value="ปี">ปี</option></select>';
text_field7 = '<select name="pay_for_sub[]" id="pay_for_sub"><option selected="selected">เลือก</option><option value="ปกติ">ปกติ</option><option value="ไม่ปกติ">ไม่ปกติ</option><option value="หยุด">หยุด</option></select>';
text_field8 = '<input type="text" name="rent_for_sub[]" id="rent_for_sub" />';
text_field8+='<img src="img/b_drop.png" title="ลบ" id="new_addpay'+numRow+'_db" align="absmiddle" height="18" onClick="deletepay(\'new_addpay'+numRow+'\');" style="cursor:pointer;">';
// text_field10 = '<div id="div_sex_'+numRow+'">'+ sex.value+'<input type="hidden" name="sex[]" id="sex_'+numRow+'" value="'+sex.value+'" ></div>';
// text_field11 ='<div id="div_career_'+numRow+'">'+ sick.value+'<input type="hidden" name="sick[]" id="career_'+numRow+'" value="'+sick.value+'" ></div>';
// text_field12 ='<div id="div_sick_'+numRow+'">'+ sick.value+'<input type="hidden" name="sick[]" id="sick_'+numRow+'" value="'+sick.value+'" ></div >';
// text_field13 ='<div id="div_gim_'+numRow+'">'+ gimp.value+'<input type="hidden" name="gimp[]" id="gimp_'+numRow+'" value="'+gimp.value+'" ></div>';
// text_field14 ='<div id="div_old_'+numRow+'">'+ old.value+'<input type="hidden" name="old[]" id="old_'+numRow+'" value="'+old.value+'" ></div>';
// text_field15 ='<div id="div_spacial_'+numRow+'">'+spacial.value'<input type="hidden" name="spacial[]" id="spacial_'+numRow+'"value="" ></div>';
//Text TD
//insetTB.style.backgroundColor = "#FFFFFF";
insetTB.style.height='20px';
td1.innerHTML = text_field1;
td2.innerHTML = text_field2;
td3.innerHTML = text_field3;
td4.innerHTML = text_field4;
td5.innerHTML = text_field5;
td6.innerHTML = text_field6;
td7.innerHTML = text_field7;
td8.innerHTML = text_field8;
// td9.innerHTML = text_field9;
// td10.innerHTML = text_field10;
// td11.innerHTML = text_field11;
// td12.innerHTML = text_field12;
// td13.innerHTML = text_field13;
// td14.innerHTML = text_field14;
td1.style.textAlign = "center";
td2.style.textAlign = "center";
td3.style.textAlign = "center";
td4.style.textAlign = "center";
td5.style.textAlign = "center";
td6.style.textAlign = "center";
td7.style.textAlign = "center";
td8.style.textAlign = "center";
code_id.value='';
name.value='';
lastname.value='';
status.value = '';
age.value = '';
sex.value = '';
education.value ='';
career.value ='';
salary.value = '';
pay.value='';
sick.value = '';
gimp.value ='';
old.value ='';
spacial.value='';
}
function checkCodeId(code_id){
if(code_id.value !="") {
//alert(code_id.value);
var id = code_id.value;
var x = new String(id);
splitext = x.split("");
var total = 0;
var mul = 13;
for(i=0;i<splitext.length-1;i++)
{
total = total + splitext[i] * mul;
mul = mul -1;
}
mod = total % 11;
nsub = 11 - mod;
mod2 = nsub % 10;
if(mod2!=splitext[12]){
//alert("เลขบัตรประจำตัวประชาชนไม่ถูกต้อง");
document.getElementById('txt_code_id1').innerHTML='<img src="img/icon-warning.png" align="absmiddle" border="0"><font color="#FF0000"><b>เลขบัตรประจำตัวประชาชนไม่ถูกต้อง</b></font>';
code_id.focus() ;
}
}
}
function deletepay(my_id){
var i=document.getElementById(my_id+'_db').parentNode.parentNode.rowIndex;
document.getElementById('TBL_INSERT').deleteRow(i);
}
/*function editRow(my_id){
var code_id=document.getElementById('code_id1');
var name=document.getElementById('name1');
var lastname=document.getElementById('lastname1');
var status = document.getElementById('status');
var age = document.getElementById('age1');
var sex1 = document.getElementById('sex1');
var sex2 = document.getElementById('sex2');
var education = document.getElementById('education');
var career = document.getElementById('career');
var salary = document.getElementById('salary1');
var pay = document.getElementById('pay1');
var sick = document.getElementById('sick1');
var gimp = document.getElementById('gimp1');
var old = document.getElementById('old1');
var spacial = document.getElementById('spacial1');
//alert (pay.value);
code_id.value = document.getElementById('code_id_'+my_id).value;
name.value=document.getElementById('name_'+my_id).value;
lastname.value=document.getElementById('lastname_'+my_id).value;
status.value=document.getElementById('status_'+my_id).value;
sex.value=document.getElementById('sex_'+my_id).value;
education.value=document.getElementById('education_'+my_id).value;
// alert (document.getElementById('age_'+my_id).value);
age.value=document.getElementById('age_'+my_id).value;
career.value=document.getElementById('career_'+my_id).value;
salary.value=document.getElementById('salary_'+my_id).value;
pay.value=document.getElementById('pay_'+my_id).value;
sick.value=document.getElementById('sick_'+my_id).value;
old.value=document.getElementById('old_'+my_id).value;
gimp.value=document.getElementById('gimp_'+my_id).value;
spacial.value=document.getElementById('spacial'+my_id).value;
if(sex.value=="ชาย") {
sex1.checked=true;
}else {
sex2.checked=true;
}
if(sick.value=="ป่วยเรื้อรัง"){
sick.selected=true;
}else if (old.value=="สูงอายุ"){
old.selected=true;
} else if (gimp=="พิการ") {
gimp.selected=true;
}
document.getElementById('button_item').innerHTML='<input type="button" value="แก้ไขข้อมูล" onClick="editData('+my_id+');">';
//alert (document.getElementById('button_item').innerHTML);
}
//function editData(numRow){
var code_id=document.getElementById('code_id1');
var name=document.getElementById('name1');
var lastname=document.getElementById('lastname1');
var status = document.getElementById('status');
var age = document.getElementById('age1');
var sex = document.getElementById('sex');
var education = document.getElementById('education');
var career = document.getElementById('career');
var salary = document.getElementById('salary1');
var pay = document.getElementById('pay1');
var sick = document.getElementById('sick1');
var gimp = document.getElementById('gimp1');
var old = document.getElementById('old1');
var spacial = document.getElementById('spacial1');
text_field2 = code_id.value+'<input type="hidden" name="code_id[]" id="code_id_'+numRow+'" value="'+code_id.value+'" >';
document.getElementById('div_code_id_'+numRow).innerHTML=text_field2;
text_field3 = name.value+'<input type="hidden" name="name[]" id="name_'+numRow+'" value="'+name.value+'" >';
document.getElementById('div_name_'+numRow).innerHTML=text_field3;
text_field4 = lastname.value+'<input type="hidden" name="lastname[]" id="lastname_'+numRow+'" value="'+lastname.value+'" >';
document.getElementById('div_lastname_'+numRow).innerHTML=text_field4;
text_field5 =age.value+'<input type="hidden" name="age[]" id="age_'+numRow+'" value="'+age.value+'" >';
document.getElementById('div_age_'+numRow).innerHTML=text_field5;
document.getElementById('button_item').innerHTML='<input type="button" value="เพิ่มข้อมูล" onClick="addItemNew();">';
//alert('แก้ไขข้อมูลเรียบร้อย');
code_id.value='';
name.value='';
lastname.value='';
status.value = '';
age.value = '';
sex.value = '';
education.value ='';
career.value ='';
salary.value = '';
pay.value='';
sick.value = '';
gimp.value ='';
old.value ='';
spacial.value='';
}*/
</SCRIPT>
<table width="100%" border="0" cellspacing="5" cellpadding="0">
<tr>
<td><table width="100%" border="1" id="TBL_INSERT">
<tr>
<td rowspan="2" width="20%"><div align="center">ประเภท</div></td>
<td rowspan="2" width="10%"><div align="center">จำนวนเงินกู้คงเหลือ</div></td>
<td rowspan="2" width="10%"><div align="center">ระยะเวลากู้</div></td>
<td rowspan="2" width="10%"><div align="center">ดอกเบี้ย</div></td>
<td colspan="2" width="20%"><div align="center">จำนวนเงินชำระคืน</div></td>
<td rowspan="2" width="10%"><div align="center">การชำระหนี้</div></td>
<td rowspan="2" width="30%"><div align="center">กู้ไปทำอะไร</div></td>
</tr>
<tr>
<td width="10%" colspan="1"><div align="center">บาท</div></td>
<td height="25" width="10%"><div align="center">การชำระ</div> </td>
</tr> <?php /*?> <?
$strSQL_6 = "SELECT count(run_id) as id
FROM pauper_surway_debt
WHERE run_id='".$_GET['runid']."'";
$rsConn_6 = mysql_db_query($dbname,$strSQL_6);
$strSQL_7= "SELECT *
FROM pauper_surway_debt
WHERE
pauper_surway_debt.run_id = '".$_GET['runid']."' AND
'' = ''
GROUP BY
pauper_surway_debt.type_debt
ORDER BY
pauper_surway_debt.debt_id ASC ";
$rsConn_7 = mysql_db_query($dbname,$strSQL_7);
$num_row=0;
$row_count = mysql_fetch_assoc($rsConn_6);
if($num_row<$row_count[id]){
while($row_debt = mysql_fetch_assoc($rsConn_7)){
?><?php */?>
<tr>
<td height="28">1.หนี้ในระบบของชุมชน </td>
<td colspan="7"> </td>
</tr>
<?
$arr1[1]=array(caption=>'สหกรณ์');
$arr1[2]=array(caption=>'เครือข่าย');
$arr1[3]=array(caption=>'กองทุนหมู่บ้าน');
$arr1[4]=array(caption=>'กลุ่มออมทรัพย์');
$arr1[5]=array(caption=>'กลุ่ม/กองทุน อื่นๆ');
$arr1[6]=array(caption=>'ธนาคารหมู่บ้าน');
$i_1=0;
//while($res_1_1=mysql_fetch_assoc($rs_1_1)){
$numTemp=count($arr1);
for($i=1;$i<=$numTemp;$i++){
$i_1++;
$sql_1=" SELECT
pauper_surway_debt.debt_id,
pauper_surway_debt.run_id,
pauper_surway_debt.type_debt,
pauper_surway_debt.name_debt,
pauper_surway_debt.num,
pauper_surway_debt.money_debt_ex,
pauper_surway_debt.time_debt,
pauper_surway_debt.interest,
pauper_surway_debt.money_debt,
pauper_surway_debt.per_date,
pauper_surway_debt.pay_for,
pauper_surway_debt.rent_for
FROM pauper_surway_debt
WHERE run_id='".$_GET['runid']."' AND name_debt='".$arr1[$i][caption]."'
ORDER BY pauper_surway_debt.debt_id
";
//echo $sql_1;
$rs_1=mysql_db_query($dbname,$sql_1);
$res_1=mysql_fetch_assoc($rs_1);
?>
<tr>
<td>
<?=$i_1?>)<?=$arr1[$i][caption]?> <input type="hidden" name="type_debt[]" id="type_debt" value="หนี้ในระบบของชุมชน"/> <input type="hidden" name="name_debt[]" id="name_debt" value="<?=$arr1[$i][caption]?>"/> <input type="hidden" name="num[]" id="num" /> </td>
<td><div align="center">
<input type="text" name="money_debt_ex[]" id="money_debt_ex" size="10" value="<?=($_POST['money_debt_ex']=='')?$res_1['money_debt_ex']:$_POST['money_debt_ex']?>" onKeyPress="return isNumber(event,this.id);" />
</div></td>
<td><div align="center">
<input type="text" name="time_debt[]" id="time_debt" size="10" value="<?=($_POST['time_debt']=='')?$res_1['time_debt']:$_POST['time_debt']?>" onKeyPress="return isNumber(event,this.id);"/>
</div></td>
<td><div align="center">
<input type="text" name="interrest[]" id="interrest" size="10" value="<?=($_POST['interrest']=='')?$res_1['interest']:$_POST['interrest']?>" onKeyPress="return isNumber(event,this.id);"/>
</div></td>
<td><div align="center">
<input type="text" name="money_debt[]" id="money_debt" size="10" value="<?=($_POST['money_debt']=='')?$res_1['money_debt']:$_POST['money_debt']?>" onKeyPress="return isNumber(event,this.id);"/>
</div></td>
<td width="10%"><div align="center">
<select name="per_date[]" id="per_date">
<option>เลือก</option>
<option value="วัน" <?=($res_1['per_date']=='วัน')?'selected="selected"':''?>>วัน</option>
<option value="เดือน" <?=($res_1['per_date']=='เดือน')?'selected="selected"':''?>>เดือน</option>
<option value="ปี" <?=($res_1['per_date']=='ปี')?'selected="selected"':''?>>ปี</option>
</select>
</div> </td>
<td><div align="center">
<select name="pay_for[]" id="pay_for[]" >
<option selected="selected">เลือก</option>
<option value="ปกติ" <?=($res_1['pay_for']=='ปกติ')?'selected="selected"':''?>>ปกติ</option>
<option value="ไม่ปกติ" <?=($res_1['pay_for']=='ไม่ปกติ')?'selected="selected"':''?>>ไม่ปกติ</option>
<option value="หยุด" <?=($res_1['pay_for']=='หยุด')?'selected="selected"':''?>>หยุด</option>
</select>
</div> </td>
<td><div align="center">
<input type="text" name="rent_for[]" id="rent_for" value="<?=($_POST['rent_for']=='')?$res_1['rent_for']:$_POST['rent_for']?>" />
</div></td>
</tr>
<? }?>
<tr>
<td>2.หนี้นอกระบบ</td>
<td colspan="7"> </td>
</tr>
<tr>
<?
$arr2[1]=array(caption=>'เจ้าหนี้ในชุมชน');
$arr2[2]=array(caption=>'เจ้าหนี้นอกชุมชน');
$arr2[3]=array(caption=>'ญาติพี่น้อง');
$i_1=0;
//while($res_1_1=mysql_fetch_assoc($rs_1_1)){
$numTemp=count($arr2);
for($i=1;$i<=$numTemp;$i++){
$i_1++;
$sql_2=" SELECT
pauper_surway_debt.debt_id,
pauper_surway_debt.run_id,
pauper_surway_debt.type_debt,
pauper_surway_debt.name_debt,
pauper_surway_debt.num,
pauper_surway_debt.money_debt_ex,
pauper_surway_debt.time_debt,
pauper_surway_debt.interest,
pauper_surway_debt.money_debt,
pauper_surway_debt.per_date,
pauper_surway_debt.pay_for,
pauper_surway_debt.rent_for
FROM pauper_surway_debt
WHERE run_id='".$_GET['runid']."' AND name_debt='".$arr2[$i][caption]."'
ORDER BY pauper_surway_debt.debt_id
";
//echo $sql_1;
$rs_2=mysql_db_query($dbname,$sql_2);
$res_2=mysql_fetch_assoc($rs_2);
?>
<td>-<?=$arr2[$i][caption]?>
<input type="hidden" name="type_debt[]" id="type_debt" value="หนี้นอกระบบ"/> <input type="hidden" name="name_debt[]" id="name_debt" value="<?=$arr2[$i][caption]?>" /> <input type="text" name="num[]" id="num" size="5" value="<?=($_POST['num']=='')?$res_2['num']:$_POST['num']?>" onKeyPress="return isNumber(event,this.id)"/>ราย</td>
<td><div align="center">
<input type="text" name="money_debt_ex[]" id="money_debt_ex" size="10" value="<?=($_POST['money_debt_ex']=='')?$res_2['money_debt_ex']:$_POST['money_debt_ex']?>" onKeyPress="return isNumber(event,this.id)"/>
</div></td>
<td><div align="center">
<input type="text" name="time_debt[]" id="time_debt" size="10" value="<?=($_POST['time_debt']=='')?$res_2['time_debt']:$_POST['time_debt']?>" onKeyPress="return isNumber(event,this.id)"/>
</div></td>
<td><div align="center">
<input type="text" name="interrest[]" id="interrest" size="10" value="<?=($_POST['interrest']=='')?$res_2['interest']:$_POST['interrest']?>" onKeyPress="return isNumber(event,this.id)"/>
</div></td>
<td><div align="center">
<input type="text" name="money_debt[]" id="money_debt" size="10" value="<?=($_POST['money_debt']=='')?$res_2['money_debt']:$_POST['money_debt']?>" onKeyPress="return isNumber(event,this.id)"/>
</div></td>
<td width="10%"><div align="center">
<select name="per_date[]" id="per_date[]">
<option>เลือก</option>
<option value="วัน" <?=($res_2['per_date']=='วัน')?'selected="selected"':''?>>วัน</option>
<option value="เดือน" <?=($res_2['per_date']=='เดือน')?'selected="selected"':''?>>เดือน</option>
<option value="ปี" <?=($res_2['per_date']=='ปี')?'selected="selected"':''?>>ปี</option>
</select>
</div> </td>
<td><div align="center">
<select name="pay_for[]" id="pay_for[]" >
<option selected="selected">เลือก</option>
<option value="ปกติ" <?=($res_2['pay_for']=='ปกติ')?'selected="selected"':''?>>ปกติ</option>
<option value="ไม่ปกติ" <?=($res_2['pay_for']=='ไม่ปกติ')?'selected="selected"':''?>>ไม่ปกติ</option>
<option value="หยุด" <?=($res_2['pay_for']=='หยุด')?'selected="selected"':''?>>หยุด</option>
</select>
</div> </td>
<td><div align="center">
<input type="text" name="rent_for[]" id="rent_for[]" value="<?=($_POST['rent_for']=='')?$res_2['rent_for']:$_POST['rent_for']?>" size="35" />
</div></td>
</tr>
<? }?>
<tr>
<td>3.สถาบันการเงิน</td>
<td colspan="7"> </td>
</tr>
<?
$arr3[1]=array(caption=>'ธนาคารออมสิน');
$arr3[2]=array(caption=>'ธกส.');
$arr3[3]=array(caption=>'ธนาคารอื่นๆ');
$i_1=0;
//while($res_1_1=mysql_fetch_assoc($rs_1_1)){
$numTemp=count($arr3);
for($i=1;$i<=$numTemp;$i++){
$i_1++;
$sql_3=" SELECT
pauper_surway_debt.debt_id,
pauper_surway_debt.run_id,
pauper_surway_debt.type_debt,
pauper_surway_debt.name_debt,
pauper_surway_debt.num,
pauper_surway_debt.money_debt_ex,
pauper_surway_debt.time_debt,
pauper_surway_debt.interest,
pauper_surway_debt.money_debt,
pauper_surway_debt.per_date,
pauper_surway_debt.pay_for,
pauper_surway_debt.rent_for
FROM pauper_surway_debt
WHERE run_id='".$_GET['runid']."' AND name_debt='".$arr3[$i][caption]."'
ORDER BY pauper_surway_debt.debt_id ";
//echo $sql_3;
//echo '<br>';
$rs_3=mysql_db_query($dbname,$sql_3);
$res_3=mysql_fetch_assoc($rs_3);
?>
<tr>
<td> <?=$i_1?>)<?=$arr3[$i][caption]?>
<input type="hidden" name="type_debt[]" id="type_debt" value="สถาบันการเงิน"/>
<input type="hidden" name="name_debt[]" id="name_debt" value="<?=$arr3[$i][caption]?>" />
<input type="hidden" name="num[]" id="num" size="5"/></td>
<td><div align="center">
<input type="text" name="money_debt_ex[]" id="money_debt_ex" size="10" value="<?=($_POST['money_debt_ex']=='')?$res_3['money_debt_ex']:$_POST['money_debt_ex']?>" onKeyPress="return isNumber(event,this.id)"/>
</div></td>
<td><div align="center">
<input type="text" name="time_debt[]" id="time_debt" size="10" value="<?=($_POST['time_debt']=='')?$res_3['time_debt']:$_POST['time_debt']?>"onKeyPress="return isNumber(event,this.id)" />
</div></td>
<td><div align="center">
<input type="text" name="interrest[]" id="interrest" size="10" value="<?=($_POST['interrest']=='')?$res_3['interest']:$_POST['interrest']?>" onKeyPress="return isNumber(event,this.id)"/>
</div></td>
<td><div align="center">
<input type="text" name="money_debt[]" id="money_debt" size="10" value="<?=($_POST['money_debt']=='')?$res_3['money_debt']:$_POST['money_debt']?>" onKeyPress="return isNumber(event,this.id)" />
</div></td>
<td width="10%"><div align="center">
<select name="per_date[]" id="per_date" >
<option>เลือก</option>
<option value="วัน" <?=($res_3['per_date']=='วัน')?'selected="selected"':''?>>วัน</option>
<option value="เดือน" <?=($res_3['per_date']=='เดือน')?'selected="selected"':''?>>เดือน</option>
<option value="ปี" <?=($res_3['per_date']=='ปี')?'selected="selected"':''?>>ปี</option>
</select>
</div> </td>
<td><div align="center">
<select name="pay_for[]" id="pay_for">
<option selected="selected">เลือก</option>
<option value="ปกติ" <?=($res_3['pay_for']=='ปกติ')?'selected="selected"':''?>>ปกติ</option>
<option value="ไม่ปกติ" <?=($res_3['pay_for']=='ไม่ปกติ')?'selected="selected"':''?>>ไม่ปกติ</option>
<option value="หยุด" <?=($res_3['pay_for']=='หยุด')?'selected="selected"':''?>>หยุด</option>
</select>
</div> </td>
<td><div align="center">
<input type="text" name="rent_for[]" id="rent_for" value="<?=($_POST['rent_for']=='')?$res_3['rent_for']:$_POST['rent_for']?>" size="35" />
</div></td>
</tr>
<? }?>
<tr>
<td>4.สินค้าเงินผ่อน <SPAN style="cursor:pointer;" onClick="addforpay()">เพิ่มข้อมูล <IMG src="../../images_sys/icon.plus.gif" border="0" width="18" height="12"></SPAN>
<input type="hidden" name="note_fileTEMP8" id="note_fileTEMP8" value="" /></td>
<td colspan="7"><ol id="files-rootpay"></ol></td>
</tr>
<?
$sql_4_4=" SELECT
pauper_surway_debt.debt_id,
pauper_surway_debt.run_id,
pauper_surway_debt.type_debt,
pauper_surway_debt.name_debt,
pauper_surway_debt.num,
pauper_surway_debt.money_debt_ex,
pauper_surway_debt.time_debt,
pauper_surway_debt.interest,
pauper_surway_debt.money_debt,
pauper_surway_debt.per_date,
pauper_surway_debt.pay_for,
pauper_surway_debt.rent_for
FROM pauper_surway_debt
WHERE run_id='".$_GET['runid']."' AND type_debt='สินค้าเงินผ่อน'
ORDER BY pauper_surway_debt.debt_id
";
//echo $sql_1;
$rs_4_4=mysql_db_query($dbname,$sql_4_4);
$i_4=0;
while($res_4_4=mysql_fetch_assoc($rs_4_4)){
$i_4++;
$sql_4=" SELECT
pauper_surway_debt.debt_id,
pauper_surway_debt.run_id,
pauper_surway_debt.type_debt,
pauper_surway_debt.name_debt,
pauper_surway_debt.num,
pauper_surway_debt.money_debt_ex,
pauper_surway_debt.time_debt,
pauper_surway_debt.interest,
pauper_surway_debt.money_debt,
pauper_surway_debt.per_date,
pauper_surway_debt.pay_for,
pauper_surway_debt.rent_for
FROM pauper_surway_debt
WHERE run_id='".$_GET['runid']."' AND name_debt='".$res_4_4['name_debt']."'
ORDER BY pauper_surway_debt.debt_id ";
$rs_4=mysql_db_query($dbname,$sql_4);
$res_4=mysql_fetch_assoc($rs_4);
?>
<tr id="file_debt-<?=$i_4?>"><input type="hidden" name="type_debt_sub[]" id="type_debt_sub[]" value="สินค้าเงินผ่อน" />
<td align="center"><input type="text" name="name_debt_sub[]" value="<?=($_POST['name_debt_sub']=='')?$res_4['name_debt']:$_POST['name_debt_sub']?>"></td>
<td><div align="center">
<input type="text" name="money_debt_ex_sub[]" id="money_debt_ex_sub" size="10" value="<?=($_POST['money_debt_ex_sub']=='')?$res_4['money_debt_ex']:$_POST['money_debt_ex_sub']?>" onKeyPress="return isNumber(event,this.id)"/>
</div></td>
<td><div align="center">
<input type="text" name="time_debt_sub[]" id="time_debt_sub" size="10" value="<?=($_POST['time_debt_sub']=='')?$res_4['time_debt']:$_POST['time_debt_sub']?>"onKeyPress="return isNumber(event,this.id)" />
</div></td>
<td><div align="center">
<input type="text" name="interrest_sub[]" id="interrest_sub" size="10" value="<?=($_POST['interrest_sub']=='')?$res_4['interest']:$_POST['interrest_sub']?>" onKeyPress="return isNumber(event,this.id)"/>
</div></td>
<td><div align="center">
<input type="text" name="money_debt_sub[]" id="money_debt_sub" size="10" value="<?=($_POST['money_debt_sub']=='')?$res_4['money_debt']:$_POST['money_debt_sub']?>" onKeyPress="return isNumber(event,this.id)" />
</div></td>
<td width="10%"><div align="center">
<select name="per_date_sub[]" id="per_date_sub" >
<option>เลือก</option>
<option value="วัน" <?=($res_4['per_date']=='วัน')?'selected="selected"':''?>>วัน</option>
<option value="เดือน" <?=($res_4['per_date']=='เดือน')?'selected="selected"':''?>>เดือน</option>
<option value="ปี" <?=($res_4['per_date']=='ปี')?'selected="selected"':''?>>ปี</option>
</select>
</div> </td>
<td><div align="center">
<select name="pay_for_sub[]" id="pay_for_sub">
<option selected="selected">เลือก</option>
<option value="ปกติ" <?=($res_4['pay_for']=='ปกติ')?'selected="selected"':''?>>ปกติ</option>
<option value="ไม่ปกติ" <?=($res_4['pay_for']=='ไม่ปกติ')?'selected="selected"':''?>>ไม่ปกติ</option>
<option value="หยุด" <?=($res_4['pay_for']=='หยุด')?'selected="selected"':''?>>หยุด</option>
</select>
</div> </td>
<td><div align="center">
<input type="text" name="rent_for_sub[]" id="rent_for_sub" value="<?=($_POST['rent_for']=='')?$res_4['rent_for']:$_POST['rent_for']?>" />
<span onclick="removeFile8('file_debt-<?=$i_4?>','<?=$i_4?>')" style="cursor:pointer;"> <img src="img/b_drop.png" border="0" width="18"></span>
</div> </td>
</tr>
<? }?>
</table>
</td>
</tr>
</table>