大四学生IT企业求职经验全记录

版权申诉
0 下载量 11 浏览量 更新于2024-10-06 收藏 46KB RAR 举报
资源摘要信息:"本文档提供了关于求职过程的详细记录,特别针对IT行业的求职者。文档中不仅包括了求职者本人的大四求职经历,而且详细介绍了在申请IT企业职位时所经历的笔试和面试环节。文档的标题和描述表明,该求职者曾申请多家知名IT公司,并在其中积累了宝贵的经验。这份记录不仅对当前正在求职的大学生或者准备进入职场的人员有参考价值,也对那些希望了解求职流程和面试技巧的专业人士提供了实用的信息。 文档内容可能涉及以下几个方面: 1. 求职准备:求职者在文档中可能记录了自己如何为求职做准备,包括制作简历、准备求职信、整理作品集或者项目经验等。对于IT求职者来说,这部分可能还包括了如何针对不同职位优化技术技能和知识点的准备。 2. 公司选择:求职者可能会谈到如何根据自己的专业背景、兴趣和职业规划来选择合适的IT企业。这部分内容可能涉及到各大IT企业的文化、业务范围、发展前景和招聘需求等。 3. 笔试经历:文档中可能详细描述了各种IT企业的笔试流程,包括笔试题型、考题范围以及个人应对策略等。例如,对于编程岗位可能涉及到算法与数据结构、软件开发流程、代码调试等内容。 4. 面试技巧:求职者在文档中可能分享了在面试过程中遇到的各种类型问题,例如行为面试问题、技术面试问题,以及面试官的评价标准。此外,还有可能介绍了一些面试前的准备技巧和面试当天的注意事项。 5. 求职总结:在文档的最后,求职者可能会总结自己的求职经验,提供一些面试和求职的建议,以及反思在求职过程中遇到的问题和自身的不足。 由于文件标题中包含了“.rar_it”,这表明该文档可能是经过压缩打包的文件,仅有一个包含求职经历记录的文档“求职记.docx”。对于有意向获取这份资源的读者来说,这将是一个了解IT行业求职现状,学习求职和面试技巧的好机会。"

优化以下SQL select pao.id, pao.order_no, pao.apply_time, pao.purchase_user_id, pao.purchase_user_name, pao.apply_user_id, pao.apply_user_name, pao.apply_department_id, pao.apply_department_name, pao.apply_end_time, pao.create_user_id, pao.create_user_name, pao.approve_type, pao.approve_user_id, pao.approve_user_name, pao.approve_time, pao.description, pao.order_type, pao.purchase_type, pao.storage_type, pao.compose_order_no, pao.company_id, pao.delete, pao.create_time, pao.update_time, pao.supplier_id, pao.image_path, pao.contract_id, pao.status, pao.invoice_signer_name, pao.total_amount, pao.total_amount_tax, pao.purchase_status, pao.cancel_reason, pao.print_status, pao.demand_id, pao.arrival_status, pao.supervise_num, pao.supervise_date, pao.merge_apply_id, pao.deadline, pao.remind , s.name as supplierName, paod.amount, cm.return_status as returnStatus, cm.inventory_status as inventoryStatus, cm.stock_remark, cm.merge_flag, cm.signature_file, cm.department_pass, cm.receipt_file, cm.amount_paid, cm.amount_unpaid, cm.contract_name, cm.status as contractStatus, cm.contract_no, cm.contract_amount, paod.product_name, cm.advance_payment, cm.advance_ratio, cm.currency_unit from purchase_apply_order pao left join supplier s on pao.supplier_id = s.id left join ( SELECT GROUP_CONCAT(distinct p.product_name) product_name, sum(IFNULL(amount_tax, 0)) amount, apply_order_no from purchase_apply_order_details pa left join product p on p.pn_code = pa.product_code where p.company_id = 29 GROUP BY apply_order_no ) paod on paod.apply_order_no = pao.order_no left join contract_management cm on pao.contract_id = cm.id where pao.delete = 0 and pao.company_id = 29 and deadline <= '2023-05-25 15:34:00.01' and remind = 0 and arrival_status in( 0 , 1 ) order by pao.create_time desc;

2023-05-25 上传

SELECT t1.supplier_id, t1.ky_count, t1.ky_amount, IFNULL(t2.ky_refund_count,0) as ky_refund_count, IFNULL(t2.ky_refund_amount,0) as ky_refund_amount FROM ( SELECT a.supplier_id, count( DISTINCT c.order_no ) AS ky_count, SUM( IFNULL( c.record_amount, 0 )) / 100 AS ky_amount FROM settle_order a INNER JOIN settle_order_receipt b ON a.order_id = b.order_id INNER JOIN cash_withdrawal_record c ON b.third_trade_no = c.order_no WHERE a.is_del = 0 AND a.order_time >= '2023-05-28 00:00:00' AND a.order_time < '2023-05-29 00:00:00' AND a.order_type in (70,75) AND a.supplier_id IN (78,63,58,57,64,72,71,74,83,77,70,69,67,82,65,87,73,59,66,60,86,85,79,80,84,90) AND b.channel_code = 61 AND c.con_bank_account_no IN ( 247, 325 ) AND c.record_status = 1 AND c.record_time > '2023-05-01 00:00:00' GROUP BY a.supplier_id ) t1 LEFT JOIN ( SELECT a.supplier_id, count( DISTINCT b.order_no ) AS ky_refund_count, SUM( IFNULL( b.record_amount, 0 )) / 100 AS ky_refund_amount FROM settle_order_refund a INNER JOIN cash_withdrawal_record b ON a.third_refund_id = b.order_no WHERE a.is_del = 0 AND a.order_type in (70,75) AND a.apply_time >= '2023-05-28 00:00:00' AND a.apply_time < '2023-05-29 00:00:00' AND a.supplier_id IN (78,63,58,57,64,72,71,74,83,77,70,69,67,82,65,87,73,59,66,60,86,85,79,80,84,90) AND a.channel_code = 61 AND b.con_bank_account_no IN ( 247, 325 ) AND b.record_status = 5 AND b.record_time > '2023-05-01 00:00:00' GROUP BY a.supplier_id ) t2 ON t1.supplier_id = t2.supplier_id order by t1.supplier_id asc

2023-06-10 上传
2023-06-07 上传
2023-06-10 上传