| | |
| | | <result property="incomeTaxPayable" column="income_tax_payable" /> |
| | | <result property="taxExpertFee" column="tax_expert_fee" /> |
| | | <result property="billingInstructions" column="billing_instructions" /> |
| | | <result property="travelExpenses" column="travel_expenses" /> |
| | | <result property="accommodationFee" column="accommodation_fee" /> |
| | | </resultMap> |
| | | |
| | | <resultMap type="com.gkhy.system.domain.vo.response.ProjectExpertExportInfoRes" id="ProjectExpertExportInfoResult"> |
| | |
| | | <result property="incomeTaxPayable" column="income_tax_payable" /> |
| | | <result property="taxExpertFee" column="tax_expert_fee" /> |
| | | <result property="billingInstructions" column="billing_instructions" /> |
| | | <result property="travelExpenses" column="travel_expenses" /> |
| | | <result property="accommodationFee" column="accommodation_fee" /> |
| | | |
| | | </resultMap> |
| | | |
| | |
| | | |
| | | <sql id="selectProjectExpertVo"> |
| | | select id, project_id, expert_id, score, evaluation_state, selection_mode, team_leader, del_flag, create_by, create_time, update_by, update_time, professional_ethics, impartial_honest, comprehensive_coordination, professional_ability, expressing_opinions, others, comprehensive_evaluation, major_dangers, general_hazards, content, |
| | | freight_basis, billing_duration, after_tax_amount, open_bank, bank_card,taxable_income,income_tax_payable,tax_expert_fee,billing_instructions from project_expert |
| | | freight_basis, billing_duration, after_tax_amount, open_bank, bank_card,taxable_income,income_tax_payable,tax_expert_fee,billing_instructions,travel_expenses, accommodation_fee from project_expert |
| | | </sql> |
| | | <select id="selectProjectExpertList" parameterType="ProjectExpert" resultMap="ProjectExpertResult"> |
| | | <include refid="selectProjectExpertVo"/> |
| | |
| | | <if test="taxableIncome != null">taxable_income,</if> |
| | | <if test="incomeTaxPayable != null">income_tax_payable,</if> |
| | | <if test="taxExpertFee != null">tax_expert_fee,</if> |
| | | <if test="travelExpenses != null">travel_expenses,</if> |
| | | <if test="accommodationFee != null">accommodation_fee,</if> |
| | | </trim> |
| | | <trim prefix="values (" suffix=")" suffixOverrides=","> |
| | | <if test="projectId != null">#{projectId},</if> |
| | |
| | | <if test="taxableIncome != null"> #{taxableIncome},</if> |
| | | <if test="incomeTaxPayable != null">#{incomeTaxPayable},</if> |
| | | <if test="taxExpertFee != null">#{taxExpertFee},</if> |
| | | <if test="travelExpenses != null">#{travelExpenses},</if> |
| | | <if test="accommodationFee != null">#{accommodationFee},</if> |
| | | </trim> |
| | | </insert> |
| | | |
| | |
| | | <if test="incomeTaxPayable != null">income_tax_payable = #{incomeTaxPayable},</if> |
| | | <if test="taxExpertFee != null">tax_expert_fee = #{taxExpertFee},</if> |
| | | <if test="billingInstructions != null" > billing_instructions = #{billingInstructions},</if> |
| | | |
| | | <if test="travelExpenses != null">travel_expenses = #{travelExpenses},</if> |
| | | <if test="accommodationFee != null" > accommodation_fee = #{accommodationFee},</if> |
| | | </trim> |
| | | where id = #{id} |
| | | </update> |
| | |
| | | <select id="projectExpertExportList" parameterType="Long" resultMap="ProjectExpertExportInfoResult"> |
| | | select a.project_name ,a.dept_name,a.project_code |
| | | ,c.name,c.id_card,c.name,c.job,c.title,c.company_name,b.freight_basis,b.billing_instructions, |
| | | b.billing_duration, b.after_tax_amount, b.open_bank, b.bank_card,b.taxable_income,b.income_tax_payable,b.tax_expert_fee |
| | | b.billing_duration, b.after_tax_amount, b.open_bank, b.bank_card,b.taxable_income,b.income_tax_payable,b.tax_expert_fee,b.travel_expenses,b.accommodation_fee |
| | | from project_management a |
| | | left join project_expert b on a.id = b.project_id and b.del_flag = 0 |
| | | left join sys_expert_info c on b.expert_id = c.id |