nbfd_tp3/Home/Lib/Action/CronAction.class.php

<?php



class CronAction extends Action {
			


 
	public  function deleteWdRecords(  ){
		$config = C('ORACLE_CONFIG');
		
		$host= $config['host'];
		$port=  $config['port'];
		$instance_name= $config['instance_name'];
		$username= $config['username'];
		$password=  $config['password'];
		
		/*
		$host= '192.168.100.23';
		$port=   '1521';
		$instance_name= 'helowin';
		$username=  'DSSC3';
		$password=  'Rliandssc3';
		*/
		$conn = oci_connect($username, $password, $host.':'.$port.'/'. $instance_name,'AL32UTF8');
		if (!$conn) {
		   $e = oci_error();
		   trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
		}
		$min_id=0;
		$max_id=0;
		$query_sql='select ID from DSSC2.W_DW_RF_RECORD   where rownum = 1   order by ID Asc ';
		$stid = oci_parse($conn, $query_sql);
		oci_define_by_name($stid, 'ID', $min_id);
		oci_execute($stid);
		oci_fetch($stid);
		
		$max_id=0;
		$query_sql='select ID from DSSC2.W_DW_RF_RECORD   where rownum = 1   order by ID Desc ';
		$stid = oci_parse($conn, $query_sql);
		oci_define_by_name($stid, 'ID', $max_id);
		oci_execute($stid);
		oci_fetch($stid);
		
		$delete_id=$max_id-800000000;
		
		while($min_id<=$delete_id){
			$del_sql='DELETE FROM DSSC2.W_DW_RF_RECORD WHERE ID = 6468026663';
			$stid = oci_parse($conn, $del_sql);
		   $r = oci_execute($stid);
			$min_id++;
		
		}
		
	}
	

}