今天写的一段复杂sql语句

发布一个k8s部署视频：https://edu.youkuaiyun.com/course/detail/26967

课程内容：各种k8s部署方式。包括minikube部署，kubeadm部署，kubeasz部署，rancher部署，k3s部署。包括开发测试环境部署k8s，和生产环境部署k8s。

腾讯课堂连接地址https://ke.qq.com/course/478827?taid=4373109931462251&tuin=ba64518

第二个视频发布  https://edu.youkuaiyun.com/course/detail/27109

腾讯课堂连接地址https://ke.qq.com/course/484107?tuin=ba64518

介绍主要的k8s资源的使用配置和命令。包括configmap，pod，service，replicaset，namespace，deployment，daemonset，ingress，pv，pvc，sc，role，rolebinding，clusterrole，clusterrolebinding，secret，serviceaccount，statefulset，job，cronjob，podDisruptionbudget，podSecurityPolicy,networkPolicy,resourceQuota，limitrange，endpoint，event，conponentstatus，node，apiservice，controllerRevision等。

第三个视频发布：https://edu.youkuaiyun.com/course/detail/27574

详细介绍helm命令，学习helm chart语法，编写helm chart。深入分析各项目源码，学习编写helm插件
————————————————------------------------------------------------------------------------------------------------------------------

 

<pre name="code" class="sql"><pre name="code" class="sql">select 
  					s.number,
  					(select text from t_dict_general where number=s.category)category,
  					(select text from t_dict_general where number=s.subCategory)subCategory,
  					s.stocktakingTime,
  					(select text from t_dict_general where number=s.state)state,
  					t.number taskNumber,
  					t.isSecondStocktaking secondStocktaking,
  					(select text from t_dict_general where number=t.state) taskState,
  					(
  						select ta.number from t_stocktaking_task_area ta
  						where ta.stocktakingTask=t.number
  					)warehouseAreaList,
  					(
  						select cell.number from t_stocktaking_task_user_defined_cell udcell,t_warehouse_cell cell
  						where udcell.stocktakingTask=t.number
  							  and convert(SUBSTR(cell.number,1,19),SIGNED)>=convert(SUBSTR(udcell.cellNumStart,1,19),SIGNED)
  							  and convert(SUBSTR(cell.number,1,19),SIGNED)<=convert(SUBSTR(udcell.cellNumEnd,1,19),SIGNED)
  					)warehouseCellList,
  					t_unit.name seller,
  					(
  						select detail.warehouseCell from t_stock_detail detail
  							where seller.seller=detail.seller
  					)sellerWarehouseCellList
  					
  			 from t_stocktaking s,t_stocktaking_task_employee e,t_stocktaking_task t,
  			 	  t_stocktaking_task_user_defined_seller seller,
  			 	  t_seller ,t_unit
  			 <where>
  			 		t.stocktaking=s.number
  			 		and t.number=seller.stocktakingTask
  			 		and seller.seller=t_seller.number
  			 		and t_seller.unit=t_unit.number
  			 		and e.stocktakingTask=t.number
  			 		<if test="userCode!=null and userCode!=''">
  			 			and e.employee=#{userCode}
  			 		</if>
  			 </where> 		
  			 union
  			 
  			 select 
  					s.number,
  					(select text from t_dict_general where number=s.category)category,
  					(select text from t_dict_general where number=s.subCategory)subCategory,
  					s.stocktakingTime,
  					(select text from t_dict_general where number=s.state)state,
  					t.number taskNumber,
  					t.isSecondStocktaking secondStocktaking,
  					(select text from t_dict_general where number=t.state) taskState,
  					(
  						select ta.number from t_stocktaking_task_area ta
  						where ta.stocktakingTask=t.number
  					)warehouseAreaList,
  					(
  						select cell.number from t_stocktaking_task_user_defined_cell udcell,t_warehouse_cell cell
  						where udcell.stocktakingTask=t.number
  							  and convert(SUBSTR(cell.number,1,19),SIGNED)>=convert(SUBSTR(udcell.cellNumStart,1,19),SIGNED)
  							  and convert(SUBSTR(cell.number,1,19),SIGNED)<=convert(SUBSTR(udcell.cellNumEnd,1,19),SIGNED)
  					)warehouseCellList,
  					t_goods_sku.barCode sku,
  					(
  						select detail.warehouseCell from t_stock_detail detail
  							where sku.sku=detail.sku
  					)skuWarehouseCellList,
  			 from t_stocktaking s,t_stocktaking_task_employee e,t_stocktaking_task t,
  			 	  t_stocktaking_task_user_defined_sku sku,
  			 	  t_goods_sku
  			 <where>
  			 		t.stocktaking=s.number
  			 		and t.number=sku.stocktakingTask
  			 		and sku.sku =t_goods_sku.number
  			 		and e.stocktakingTask=t.number
  			 		<if test="userCode!=null and userCode!=''">
  			 			and e.employee=#{userCode}
  			 		</if>
  			 </where> 
  			 
  			 union 
  			 
  			 select 
  					s.number,
  					(select text from t_dict_general where number=s.category)category,
  					(select text from t_dict_general where number=s.subCategory)subCategory,
  					s.stocktakingTime,
  					(select text from t_dict_general where number=s.state)state,
  					scd.number taskNumber,
  					scd.isSecondStocktaking secondStocktaking,
  					(select text from t_dict_general where number=scd.state) taskState,
  					(
  						select ta.number from t_stocktaking_task_area ta
  						where ta.stocktakingTask=scd.number
  					)warehouseAreaList,
  					(
  						select cell.number from t_stocktaking_task_user_defined_cell udcell,t_warehouse_cell cell
  						where udcell.stocktakingTask=scd.number
  							  and convert(SUBSTR(cell.number,1,19),SIGNED)>=convert(SUBSTR(udcell.cellNumStart,1,19),SIGNED)
  							  and convert(SUBSTR(cell.number,1,19),SIGNED)<=convert(SUBSTR(udcell.cellNumEnd,1,19),SIGNED)
  					)warehouseCellList,
  					r.number firstRecord,
  					r.warehouseCell secondListWarehouseCell,
  					r.sku secondListSku
  			 from t_stocktaking s,t_stocktaking_task_employee e,t_stocktaking_task t,t_stocktaking_task scd
  			 		t_stocktaking_task_record r
  			 <where>
  			 		t.stocktaking=s.number
  			 		and scd.stocktaking=s.number
  			 		and e.stocktakingTask=t.number
  			 		and r.stocktakingTask=t.number
  			 		and r.stockQuantity!=r.stocktakingQuantity
  			 		and scd.isSecondStocktaking=1
  			 		<if test="userCode!=null and userCode!=''">
  			 			and e.employee=#{userCode}
  			 		</if>
  			 </where>