| | |
|---|
| | | </delete> |
|---|
| | | <select id="getLinkBasicPage" resultType="map"> |
|---|
| | | SELECT d.`id`, l.`entrust_coding`, l.`entrusted`, d.`samples_number`, d.`sample_name`, |
|---|
| | | d.`specifications_models`, |
|---|
| | | s.name specifications_models, |
|---|
| | | DATE_FORMAT(l.`inspection_time`,'%Y-%m-%d') inspectionTime, DATE_FORMAT(l.`completion_deadline`,'%Y-%m-%d') |
|---|
| | | completionDeadline, l.`contacts`, |
|---|
| | | DATE_FORMAT(d.`date_survey`,'%Y-%m-%d') dateSurvey, d.`inspection_status`, |
|---|
| | | DATE_FORMAT(l.`ins_time`,'%Y-%m-%d') insTime |
|---|
| | | FROM link_basic_information l, link_detection d |
|---|
| | | FROM link_basic_information l, link_detection d,specifications s |
|---|
| | | WHERE l.`id` = d.`link_basic_id` |
|---|
| | | and s.id=d.`specifications_models` |
|---|
| | | AND d.`state` = 1 |
|---|
| | | and l.`state` = 1 |
|---|
| | | <if test="entrustCoding != null and entrustCoding != null"> |
|---|
