bugs.php

国外的人才求职招聘最新版

	    fputs($fp,"Content-type: application/x-www-form-urlencoded\r\n");
	    fputs($fp, "Content-length: " . strlen($data) . "\r\n");
	    fputs($fp, "User-Agent: ".$_SERVER['HTTP_USER_AGENT']."\r\n");
	    fputs($fp, "Connection: close\r\n\r\n");
	    fputs($fp, $data);

	    $bugSent = false;
	    $ostr = '';
	    while (!feof($fp)) {
	        $ostr .= fgets($fp,128);

	        if(strstr($ostr, 'Item Successfully Created') !== false) {
	        	$bugSent = true;
	        	break;
	        }
	    }

	    fclose($fp);
		return $bugSent;
	}

	function updateBugs(){
		$arrFieldList[0] = "'". $this->getBugId() . "'";
		$arrFieldList[1] = "'". $this->getBugNumber() . "'";
		$arrFieldList[2] = "'". $this->getDateModified() . "'";
		$arrFieldList[3] = 'null'; //"'". $this->getAssignedDeveloperId() . "'";
		$arrFieldList[4] = "'". $this->getDeleted() ."'";
		$arrFieldList[5] = "'". $this->getDescription() ."'";
		$arrFieldList[6] = "'". $this->getFixedInRelease() ."'";
		$arrFieldList[7] = "'". $this->getModifiedUserId() ."'";
		$arrFieldList[8] = "'". $this->getModule() ."'";
		$arrFieldList[9] = "'". $this->getName() ."'";
		$arrFieldList[10] = "'". $this->getPriority() ."'";
		$arrFieldList[11] = "'". $this->getResolution() ."'";
		$arrFieldList[12] = "'". $this->getSource() ."'";
		$arrFieldList[13] = "'". $this->getStatus() ."'";
		$arrFieldList[14] = "'". $this->getType() ."'";
		$arrFieldList[15] = "'". $this->getWorkLog() ."'";

		$arrRecordsList[0] = 'id';
		$arrRecordsList[1] = 'number';
		$arrRecordsList[2] = 'date_modified';
		$arrRecordsList[3] = 'assigned_developer_id';
		$arrRecordsList[4] = 'deleted';
		$arrRecordsList[5] = 'description';
		$arrRecordsList[6] = 'fixed_in_release';
		$arrRecordsList[7] = 'modified_user_id';
		$arrRecordsList[8] = 'module';
		$arrRecordsList[9] = 'name';
		$arrRecordsList[10] = 'priority';
		$arrRecordsList[11] = 'resolution';
		$arrRecordsList[12] = 'source';
		$arrRecordsList[13] = 'status';
		$arrRecordsList[14] = 'type';
		$arrRecordsList[15] = 'work_log';

		$this->sql_builder->table_name = $this->tableName;
		$this->sql_builder->flg_update = 'true';
		$this->sql_builder->arr_update = $arrRecordsList;
		$this->sql_builder->arr_updateRecList = $arrFieldList;

		$sqlQString = $this->sql_builder->addUpdateRecord1();

		$message2 = $this->dbConnection -> executeQuery($sqlQString); //Calling the addData() function

		$sysConst = new sysConf();

		$modlist = $this->getModulesCodes();
		for($c=0;count($modlist)>$c;$c++)
			if($this->getModule()==$modlist[$c][0])
				break;

		$to = $modlist[$c][2];
		$body = "Modified Date:".date("Y-m-d")."\n"."Name:".$this->getName()."\nModule: " .$modlist[$c][1]. "\nStatus:".$this->getStatus()."\n"."Priority:".$this->getPriority()."\n". "Resolution:" .$this->getResolution(). "\n". "Description:".$this->getDescription(). "\n"."WorkLog:".$this->getWorkLog();
		$subject = "Report Bug";
		$headers = 'From: ' . $sysConst->userEmail . "\r\n" .'Reply-To: ' . $sysConst->userEmail . "\r\n" ;

   		$emailSent = $this->sendMail($to,$subject,$body,$headers);

		 return array($message2,$emailSent);
	}

	function getNextNumber(){
		$arrFieldList[0] = 'number';

		$this->sql_builder->table_name = $this->tableName;
		$this->sql_builder->flg_select = 'true';
		$this->sql_builder->arr_select = $arrFieldList;

		$sqlQString = $this->sql_builder->selectOneRecordOnly();

		$message2 = $this->dbConnection -> executeQuery($sqlQString); //Calling the addData() function

		if (isset($message2)) {

			$i=0;

		while ($line = mysql_fetch_array($message2, MYSQL_ASSOC)) {
			foreach ($line as $col_value) {
			$this->singleField = $col_value;
			}
		}
		}

		return (int)($this->singleField)+1;

	}

	function filterBugs($getID) {

		$this->ID = $getID;
		$arrFieldList[0] = 'id';
		$arrFieldList[1] = 'number';
		$arrFieldList[2] = 'date_modified';
		$arrFieldList[3] = 'assigned_developer_id';
		$arrFieldList[4] = 'deleted';
		$arrFieldList[5] = 'description';
		$arrFieldList[6] = 'fixed_in_release';
		$arrFieldList[7] = 'modified_user_id';
		$arrFieldList[8] = 'module';
		$arrFieldList[9] = 'name';
		$arrFieldList[10] = 'priority';
		$arrFieldList[11] = 'resolution';
		$arrFieldList[12] = 'source';
		$arrFieldList[13] = 'status';
		$arrFieldList[14] = 'type';
		$arrFieldList[15] = 'work_log';
		$arrFieldList[16] = 'date_entered';
		$arrFieldList[17] = 'created_by';
		$arrFieldList[18] = 'found_in_release';

		$this->sql_builder->table_name = $this->tableName;
		$this->sql_builder->flg_select = 'true';
		$this->sql_builder->arr_select = $arrFieldList;

		$sqlQString = $this->sql_builder->selectOneRecordFiltered($this->ID);

		$message2 = $this->dbConnection -> executeQuery($sqlQString); //Calling the addData() function

		$i=0;

		 while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {

	    	$arrayDispList[$i][0] = $line[0];
	    	$arrayDispList[$i][1] = $line[1];
	    	$arrayDispList[$i][2] = $line[2];
	    	$arrayDispList[$i][3] = $line[3];
	    	$arrayDispList[$i][4] = $line[4];
	    	$arrayDispList[$i][5] = $line[5];
	    	$arrayDispList[$i][6] = $line[6];
	    	$arrayDispList[$i][7] = $line[7];
	    	$arrayDispList[$i][8] = $line[8];
	    	$arrayDispList[$i][9] = $line[9];
	    	$arrayDispList[$i][10] = $line[10];
	    	$arrayDispList[$i][11] = $line[11];
	    	$arrayDispList[$i][12] = $line[12];
	    	$arrayDispList[$i][13] = $line[13];
	    	$arrayDispList[$i][14] = $line[14];
	    	$arrayDispList[$i][15] = $line[15];
	    	$arrayDispList[$i][16] = $line[16];
	    	$arrayDispList[$i][17] = $line[17];
	    	$arrayDispList[$i][18] = $line[18];
	    	$i++;

	     }

	     if (isset($arrayDispList)) {

			return $arrayDispList;

		} else {

			$arrayDispList = '';
			return $arrayDispList;

		}

	}

	function getAlias($Alias){


		switch ($Alias){
			case "version":
			$returnArray = $this->getValue('hs_hr_versions','ID','name');
			break;

			case "user":
			$returnArray = $this->getValue('hs_hr_users','ID','user_name');
			break;

			case "module":
			$returnArray = $this->getValue('hs_hr_module','MOD_ID','name');
			break;

			case "developer":
			$returnArray = $this->getValue('hs_hr_developer','ID','last_name');
			break;


			default:
			$returnArray='';

		}
		return $returnArray;

	}

	function getValue($tablename, $col1,$col2){

		$tabName= $tablename;
		$arrFieldList[0] = $col1;
		$arrFieldList[1] = $col2;

		$this->sql_builder->table_name = $tabName;
		$this->sql_builder->flg_select = 'true';
		$this->sql_builder->arr_select = $arrFieldList;

		$sqlQString = $this->sql_builder->passResultSetMessage();

		$message2 = $this->dbConnection-> executeQuery($sqlQString); //Calling the addData() function

		$common_func = new CommonFunctions();

		$i=0;

		 while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {

	    	$arrayDispList[$i][0] = $line[0];
	    	$arrayDispList[$i][1] = $line[1];


	    	$i++;

	     }

	     if (isset($arrayDispList)) {

	       	return $arrayDispList;

	     } else {
	     	//echo 'fhildufidlkfn';

	     	//Handle Exceptions
	     	//Create Logs

	     }

	}

	function getArrayValues($Alias){
		switch ($Alias){
			case "status":
			$returnArray = $this->statusArray;
			break;

			case "type":
			$returnArray = $this->typeArray;
			break;

			case "priority":
			$returnArray = $this->priorityArray;
			break;

			case "source":
			$returnArray = $this->sourceArray;
			break;

			case "resolution":
			$returnArray = $this->resolutionArray;
			break;


			default:
			$returnArray='';
		}
		return $returnArray;

	}

	function sendMail($to, $subject, $body, $headers){

		$sysConf = new Conf();

		ini_set('SMTP',$sysConf->smtphost);

		//@mail($to, $subject, $body, $headers);

	return true;
	}

	function getModulesCodes() {

		$arrFieldList[0] = 'mod_id';
		$arrFieldList[1] = 'name';
		$arrFieldList[2] = 'owner_email';

		$this->sql_builder->table_name = 'hs_hr_module';
		$this->sql_builder->flg_select = 'true';
		$this->sql_builder->arr_select = $arrFieldList;

		$sqlQString =$this->sql_builder->passResultSetMessage();

		$message2 = $this->dbConnection -> executeQuery($sqlQString);

		$i=0;

		 while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {

	    	$arrayDispList[$i][0] = $line[0];
	    	$arrayDispList[$i][1] = $line[1];
	    	$arrayDispList[$i][2] = $line[2];
	    	$i++;

	     }

	     if (isset($arrayDispList)) {

			return $arrayDispList;

		} else {

			$arrayDispList = '';
			return $arrayDispList;

		}
	}

}
?>