alter table partners add column non_validate varchar(1)


$non_valid_partner=$_POST['non_validasi_partner'];

//non valid partner
				if($non_valid_partner==1)
				{
					if($status_pekerjaan=="PENDING")
					{
						$query="UPDATE spk set nik_mso='NULL',status=9,valid_by='".getNik()."',tgl_validate=CURRENT_TIMESTAMP ,resolution_time_start=date_trunc('second', TIMESTAMP '$sys_date_start'),resolution_time=date_trunc('second', TIMESTAMP '$sys_date_finish') where id_spk=$id_spk ";
						$result_query=pg_query($connection,$query);
					}
					else
					{
						$query="UPDATE spk set status=8,valid_by='".getNik()."',tgl_validate=CURRENT_TIMESTAMP ,resolution_time_start=date_trunc('second', TIMESTAMP '$sys_date_start'),resolution_time=date_trunc('second', TIMESTAMP '$sys_date_finish') where id_spk=$id_spk ";
						$result_query=pg_query($connection,$query);
					}
				}
				else
				{
					$query="UPDATE spk set status=3, resolution_time_start=date_trunc('second', TIMESTAMP '$sys_date_start'),resolution_time=date_trunc('second', TIMESTAMP '$sys_date_finish') where id_spk=$id_spk ";
					$result_query=pg_query($connection,$query);
				}
				//end non valid partner

//non valid partner
			if($non_valid_partner==1)
			{
				if($status_pekerjaan=="PENDING")
				{
					$query="UPDATE spk  SET nik_mso='NULL',resolution_time=CURRENT_TIMESTAMP, status=9,valid_by='".getNik()."',tgl_validate=CURRENT_TIMESTAMP  WHERE id_spk=$id_spk";
					$result_query=pg_query($connection,$query);
				}
				else
				{
					$query="UPDATE spk  SET resolution_time=CURRENT_TIMESTAMP, status=8,valid_by='".getNik()."',tgl_validate=CURRENT_TIMESTAMP  WHERE id_spk=$id_spk";
					$result_query=pg_query($connection,$query);
				}
			}
			else
			{
				$query="UPDATE spk  SET resolution_time=CURRENT_TIMESTAMP, status=3 WHERE id_spk=$id_spk";
				$result_query=pg_query($connection,$query);
			}
			//end non valid partner

//non valid partner
		if($non_valid_partner==1)
		{
			if($status_pekerjaan=="PENDING")
			{
				$query="UPDATE spk SET nik_mso='NULL',resolution_time=CURRENT_TIMESTAMP, status=9,valid_by='".getNik()."',tgl_validate=CURRENT_TIMESTAMP  WHERE id_spk=$id_spk";
				$result_query=pg_query($connection,$query);
			}
			else
			{
				$query="UPDATE spk  SET resolution_time=CURRENT_TIMESTAMP, status=8,valid_by='".getNik()."',tgl_validate=CURRENT_TIMESTAMP  WHERE id_spk=$id_spk";
				$result_query=pg_query($connection,$query);
			}
		}
		else
		{
			$query="UPDATE spk  SET resolution_time=CURRENT_TIMESTAMP, status=3 WHERE id_spk=$id_spk";
			$result_query=pg_query($connection,$query);
		}
		//end non valid partner

//log non valid partner
	if($non_valid_partner==1)
	{
		$messages="id_spk=$id_spk; jenis=$jenis; status_pekerjaan=$status_pekerjaan; status_spk=$status_spk;catatan_lain=$catatan_lain";
		//$query="INSERT INTO log_spk (id_spk,act,tgl_act,id_user,descr) VALUES ($id_spk,'$act',CURRENT_TIMESTAMP,'".getUserId()."','$deskripsi')";
		if ($result_query)
		{
			logSpk($id_spk,"Valid By MSO","SPK not valid");
			logActivity2($_GET['act'],"0031",$messages);
			header('location: ../main.php?module='.$_GET['module'].'&message=success&jenis='.$jenis);
		}
		else
		{
			logSpk($id_spk,"Not Valid By MSO","SPK not valid");
			logActivity2($_GET['act'],"0031",$messages);
			header('location: ../main.php?module='.$_GET['module'].'&message=error&jenis='.$jenis);
		}
	}
	else
	{
		$messages="id_spk=$id_spk; jenis=$jenis; tid=$row_spk[tid]; tid_ecash=$tid_ecash";

		if ($result_query)
		{
			logSpk($id_spk,"Submit By MSO"," $catatan ");
			logActivity2($_GET['act'],"0031",$messages);
			header('location: ../main.php?module='.$_GET['module'].'&message=success&jenis='.$jenis);
		}
		else
		{
			logSpk($id_spk,"Submit By MSO","SPK is Failed submitted ,".$result_error);
			logActivity2($_GET['act'],"0031",$messages);
			header('location: ../main.php?module='.$_GET['module'].'&message=error&jenis='.$jenis.'&res_error='.$result_error);
		}
	}
	//end log non valid partner