<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
    "/WEB-INF/dtd/sql-map-2.dtd">

<sqlMap namespace="Make">
	<typeAlias alias="make" type="com.vodacar.repository.domain.Make" />
	<resultMap id="MakeResult" class="com.vodacar.repository.domain.Make">
		<result property="id" column="ID" />
		<result property="name" column="NAME" nullValue="" />
		<result property="shortName" column="SHORTNAME" nullValue="" />
		<result property="nameEn" column="NAME_EN" nullValue="" />
		<result property="prodArea" column="PRODAREA" nullValue="0" />
		<result property="owner" column="OWNER" nullValue="" />
		
		<result property="manuName" column="MANUNAME" nullValue="" />
		<result property="manuIntroduce" column="MANUINTRODUCE" nullValue="" />
		<result property="pinyin" column="PINYIN" nullValue="" />
		<result property="description" column="DESCRIPTION" nullValue="" />
		<result property="ownerHistory" column="OWNER_HISTORY" nullValue="" />
		<result property="desginHistory" column="DESIGN_HISTORY" nullValue="" />
		<result property="mileStone" column="MILESTONE" nullValue="" />

		<result property="predecessor" column="PREDECESSOR" nullValue="" />
		<result property="makeForm" column="MAKE_FORM" nullValue="" />
		<result property="makeSource" column="MAKE_SOURCE" nullValue="" />
		<result property="makeHistory" column="MAKE_HISTORY" nullValue="" />
		<result property="prosperity" column="PROSPERITY" nullValue="" />
		<result property="stop" column="STOP" nullValue="" />
		<result property="story" column="STORY" nullValue="" />
		<result property="makePic" column="MAKE_PIC" nullValue="" />
		<result property="creator" column="CREATOR" nullValue="" />
		<result property="sort" column="SORT" nullValue="9999" />

		<result property="pass" column="PASS" nullValue="4" />
		<result property="released" column="RELEASED" />
		<result property="classId" column="classId" nullValue="0" />
	</resultMap>
	<select id="getMakeMaxId" resultClass="com.vodacar.repository.domain.Make">
		select MAX("ID") as id from "DB2ADMIN"."AUTOWIKI_MAKE"

	</select>


	<select id="retrieveMake" resultMap="MakeResult" parameterClass="long">
		SELECT make."ID", make."NAME", make."SHORTNAME", make."NAME_EN", make."PRODAREA", make."OWNER", make."MANUNAME",make."MANUINTRODUCE", make."PINYIN", make."DESCRIPTION", make."OWNER_HISTORY", make."DESIGN_HISTORY", make."MILESTONE", make."PREDECESSOR",
		make."MAKE_SOURCE", make."MAKE_FORM", make."MAKE_HISTORY", make."PROSPERITY", make."STOP", make."CREATOR", make."STORY", make."MAKE_PIC",make."SORT",make."PASS",make."RELEASED",class."ClassId" as classId from "DB2ADMIN"."AUTOWIKI_MAKE" as
		make,"DB2ADMIN"."AUTOWIKI_BRAND_CLASS" as class where make."ID"=#id# AND make."ID"=class."BrandId"

	</select>

	<update id="updateMake" parameterClass="make">
		UPDATE "DB2ADMIN"."AUTOWIKI_MAKE" SET

		<isNotEmpty property="name">"NAME" = #name#,</isNotEmpty>
		<isNotEmpty property="shortName">"SHORTNAME" = #shortName#,</isNotEmpty>
		<isNotEmpty property="nameEn">"NAME_EN" = #nameEn#,</isNotEmpty>
		<isNotEmpty property="prodArea">"PRODAREA" = #prodArea#,</isNotEmpty>
		<isNotEmpty property="owner">"OWNER" = #owner#,</isNotEmpty>
		<isNotEmpty property="manuName">"MANUNAME" = #manuName#,</isNotEmpty>
		<isNotEmpty property="manuIntroduce">"MANUINTRODUCE" = #manuIntroduce#,</isNotEmpty>
		<isNotEmpty property="pinyin">"PINYIN" = #pinyin#,</isNotEmpty>
		<isNotEmpty property="description">"DESCRIPTION" = #description#,</isNotEmpty>
		<isNotEmpty property="ownerHistory">"OWNER_HISTORY" = #ownerHistory#,</isNotEmpty>
		<isNotEmpty property="desginHistory">"DESIGN_HISTORY" = #desginHistory#,</isNotEmpty>
		<isNotEmpty property="mileStone">"MILESTONE" = #mileStone#,</isNotEmpty>
		<isNotEmpty property="predecessor">"PREDECESSOR" = #predecessor#,</isNotEmpty>
		<isNotEmpty property="makeSource">"MAKE_SOURCE" = #makeSource#,</isNotEmpty>
		<isNotEmpty property="makeForm">"MAKE_FORM" = #makeForm#,</isNotEmpty>
		<isNotEmpty property="makeHistory">"MAKE_HISTORY" = #makeHistory#,</isNotEmpty>
		<isNotEmpty property="prosperity">"PROSPERITY" = #prosperity#,</isNotEmpty>
		<isNotEmpty property="stop">"STOP" = #stop#,</isNotEmpty>
		<isNotEmpty property="creator">"CREATOR" = #creator#,</isNotEmpty>
		<isNotEmpty property="story">"STORY" = #story#,</isNotEmpty>
		<isNotEmpty property="makePic">"MAKE_PIC" = #makePic#,</isNotEmpty>
		<isNotEmpty property="sort">"SORT" = #sort#,</isNotEmpty>
		<isNotEmpty property="pass">"PASS" = #pass#,</isNotEmpty>
		<isNotEmpty property="released">"RELEASED" = #released#,</isNotEmpty>
		"ID" = #id# WHERE ID=#id#

	</update>
	<insert id="insertMake" parameterClass="make">
		INSERT INTO "DB2ADMIN"."AUTOWIKI_MAKE" 
		( "NAME", "SHORTNAME", "NAME_EN", "PRODAREA", "OWNER", "MANUNAME","MANUINTRODUCE", "PINYIN", "DESCRIPTION", "OWNER_HISTORY", "DESIGN_HISTORY", "MILESTONE", "PREDECESSOR", "MAKE_SOURCE", "MAKE_FORM", "MAKE_HISTORY",
		"PROSPERITY", "STOP", "CREATOR", "STORY", "MAKE_PIC","SORT","PASS","RELEASED")
		 VALUES 
		 ( #name#, #shortName#, #nameEn#, #prodArea#, #owner#, #manuName#,#manuIntroduce#, #pinyin#, #description#, #ownerHistory#, #desginHistory#, #mileStone# ,#predecessor#,
		#makeSource#, #makeForm#, #makeHistory#, #prosperity#, #stop#, #creator#, #story#, #makePic#,#sort#,#pass#,#released#)
		<selectKey resultClass="java.lang.Long" keyProperty="id">values IDENTITY_VAL_LOCAL()</selectKey>
	</insert>
	<delete id="deleteMake" parameterClass="long">DELETE FROM AUTOWIKI_MAKE WHERE "ID"= #id#</delete>
	<select id="getMakeByClass" resultMap="MakeResult">
		select make."ID", make."NAME", make."SHORTNAME", make."NAME_EN", make."PRODAREA", make."OWNER", make."MANUNAME",make."MANUINTRODUCE", make."PINYIN", make."DESCRIPTION", make."OWNER_HISTORY", make."DESIGN_HISTORY", make."MILESTONE", make."PREDECESSOR",
		make."MAKE_SOURCE", make."MAKE_FORM", make."MAKE_HISTORY", make."PROSPERITY", make."STOP", make."CREATOR", make."STORY", make."MAKE_PIC", make."SORT", make."PASS", make."RELEASED", class."ClassId" as classId from "DB2ADMIN"."AUTOWIKI_MAKE" as
		make,"DB2ADMIN"."AUTOWIKI_BRAND_CLASS" as class where make."ID"=class."BrandId" and class."ClassId"=#classId#
		<isGreaterThan prepend=" AND " property="pass" compareValue="0"> make."PASS"=#pass#</isGreaterThan>
	</select>
	<select id="queryMake" resultMap="MakeResult">
		select make."ID", make."NAME", make."SHORTNAME", make."NAME_EN", make."PRODAREA", make."OWNER",  make."MANUNAME",make."MANUINTRODUCE", make."PINYIN", make."DESCRIPTION", make."OWNER_HISTORY", make."DESIGN_HISTORY", make."MILESTONE", make."PREDECESSOR",
		make."MAKE_SOURCE", make."MAKE_FORM", make."MAKE_HISTORY", make."PROSPERITY", make."STOP", make."CREATOR", make."STORY", make."MAKE_PIC", make."SORT", make."PASS", make."RELEASED",bc."ClassId" as classId from "DB2ADMIN"."AUTOWIKI_MAKE" as
		make,"DB2ADMIN"."AUTOWIKI_BRAND_CLASS" as bc where make."ID"=bc."BrandId"
		<isGreaterThan prepend=" and " property="pass" compareValue="0">make."PASS" = #pass#</isGreaterThan>
		<isNotNull prepend=" and " property="id">make."ID" = #id#</isNotNull>
		<isNotNull prepend=" and " property="name">make."NAME" = #name#</isNotNull>
		<isGreaterThan prepend=" and " property="classId" compareValue="0">bc."ClassId" = #classId#</isGreaterThan>

	</select>
	
	<select id="searchMake" resultMap="MakeResult">
	   SELECT make."ID", make."NAME", make."SHORTNAME", make."NAME_EN", make."PRODAREA", make."OWNER",  make."MANUNAME",make."MANUINTRODUCE", make."PINYIN", make."DESCRIPTION", make."OWNER_HISTORY", make."DESIGN_HISTORY", make."MILESTONE", make."PREDECESSOR",
		make."MAKE_SOURCE", make."MAKE_FORM", make."MAKE_HISTORY", make."PROSPERITY", make."STOP", make."CREATOR", make."STORY", make."MAKE_PIC",make."SORT",make."PASS",make."RELEASED",class."ClassId" as classId from "DB2ADMIN"."AUTOWIKI_MAKE" as
		make,"DB2ADMIN"."AUTOWIKI_BRAND_CLASS" as class where make."ID"=class."BrandId"
        <dynamic prepend=" and ">
		<isNotNull prepend=" or " property="search">make."NAME" like #search#</isNotNull>
	    <isNotNull prepend=" or " property="search">make."SHORTNAME" like #search#</isNotNull>
	    <isNotNull prepend=" or " property="search">make."NAME_EN" like #search#</isNotNull>  
	    <isNotNull prepend=" or " property="search">make."OWNER" like #search#</isNotNull>
	    <isNotNull prepend=" or " property="search">make."DESCRIPTION" like #search#</isNotNull>
	    <isNotNull prepend=" or " property="search">make."OWNER_HISTORY" like #search#</isNotNull>
	    <isNotNull prepend=" or " property="search">make."DESIGN_HISTORY" like #search#</isNotNull>
	    <isNotNull prepend=" or " property="search">make."MAKE_SOURCE" like #search#</isNotNull>
	    <isNotNull prepend=" or " property="search">make."MAKE_FORM" like #search#</isNotNull>
	    <isNotNull prepend=" or " property="search">make."MAKE_HISTORY" like #search#</isNotNull>
	  
	   </dynamic>
	</select>
	
</sqlMap>