Example #1
0
         $strValues = "owner_first_name='{$owner_first_name}',owner_middle_name='{$owner_middle_name}',\r\n\t             owner_last_name='{$owner_last_name}',owner_street='{$owner_street}',\r\n\t             owner_legal_entity='{$owner_legal_entity}',\r\n        \t     owner_barangay_code='{$owner_barangay_code}',owner_zone_code='{$owner_zone_code}',\r\n\t             owner_district_code='{$owner_district_code}',owner_city_code='{$owner_city_code}',\r\n        \t     owner_province_code='{$owner_province_code}',owner_zip_code='{$owner_zip_code}',\r\n\t             owner_citizenship='{$owner_citizenship}',owner_civil_status='{$owner_civil_status}',\r\n        \t     owner_gender='{$owner_gender}',owner_tin_no='{$owner_tin_no}',\r\n\t             owner_icr_no='{$owner_icr_no}',owner_phone_no='{$owner_phone_no}',\r\n        \t     owner_gsm_no='{$owner_gsm_no}',owner_email_address='{$owner_email_address}',\r\n\t             owner_others='{$owner_others}',owner_birth_date='{$owner_birth_date}',\r\n\t             owner_lastupdated=now(),owner_lastupdated_by='{$usern}',edit_by='',edit_locked=0";
         $strWhere = "owner_id={$owner_id}";
         $addown->UpdateTaxPayer($strValues, $strWhere);
     }
     //      }
     $redito = "index.php?part=4&itemID_=1221&permit_type={$tag}&stat={$stat}&owner_id={$owner_id}&upOwner=UPDATE&business_id={$business_id}&busItem={$permit_type}&frmedit=yes";
     $addown = new TaxPayer();
     $strValues = "edit_by='',edit_locked=0";
     $strWhere = "owner_id='{$owner_id}'";
     $qu = mysql_query("update ebpls_owner set {$strValues} where {$strWhere}");
     setUrlRedirect($redito);
 } else {
     if ($blak == 0) {
         $addown = new TaxPayer();
         $InsValues = "'','{$owner_first_name}','{$owner_middle_name}',\r\n\t\t      '{$owner_last_name}','{$owner_legal_entity}','','{$owner_street}',\r\n\t\t      '{$owner_barangay_code}','{$owner_zone_code}','{$owner_district_code}',\r\n\t\t      '{$owner_city_code}','{$owner_province_code}','{$owner_zip_code}',\r\n\t\t      '{$owner_citizenship}','{$owner_civil_status}','{$owner_gender}',\r\n\t\t      '{$owner_tin_no}','{$owner_icr_no}','{$owner_phone_no}',\r\n\t\t      '{$owner_gsm_no}','{$owner_email_address}','{$owner_others}',\r\n\t\t      '{$owner_birth_date}',now(), now(),'{$usern}','',0";
         $addown->InsertTaxPayer($InsValues);
         $owner_id = $addown->outid;
         if ($busItem == 'CTC') {
             $asap = SelectDataWhere($dbtype, $dbLink, "ebpls_owner", "order by owner_id desc limit 1");
             $asap = FetchArray($dbtype, $asap);
             $owner_id = $asap['owner_id'];
             $redito = 'index.php?part=4&itemID_=1001&owner_id=' . $owner_id . '&ctc_type=INDIVIDUAL&busItem=CTC&comm=' . $comm;
             $search = '';
             $comm = "";
         } else {
             $redito = "index.php?part=4&class_type=Permits&itemID_=1221&permit_type={$tag}&owner_id={$owner_id}&stat={$stat}&addOwner=ADD&busItem={$permit_type}";
         }
         $addown = new TaxPayer();
         $strValues = "edit_by='',edit_locked=0";
         $strWhere = "owner_id={$owner_id}";
         $qu = mysql_query("update ebpls_owner set {$strValues} where {$strWhere}");