<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                ThinkChat2.0新版上線,更智能更精彩,支持會話、畫圖、視頻、閱讀、搜索等,送10W Token,即刻開啟你的AI之旅 廣告
                ``` select a.`sales_id` as '銷售ID', `u`.`username` as '銷售名稱', `u`.`phone` as '銷售手機號', a.`settle_month` as '銷售月份', a.sum_money as '個人新增訂單總額', a.order_group as '個人訂單', b.sum_money as '企業新增訂單總額', b.order_group as '企業訂單', a.sum_money - b.sum_money as '個人訂單 - 企業訂單(差值)' from ( select concat(`sales_id`, `settle_month`) as 'salesmonth', sales_id as 'sales_id', settle_month as 'settle_month', sum(`new_amount`) as 'sum_money', GROUP_CONCAT(concat(`order_id`, '(', `new_amount`,')')) as 'order_group' from `sales_perform_bind_order_settled_detail` where settle_month in (202310, 202311, 202312) group by salesmonth ) a LEFT JOIN ( select concat(d.`sales_id`, d.`settle_month`) as 'salesmonth', d.sales_id as 'sales_id', d.settle_month as 'settle_month', sum(d.`new_amount`) as 'sum_money', GROUP_CONCAT(concat(`order_id`, '(', `new_amount`,')')) as 'order_group' from `sales_perform_bind_order_settled_detail` `d` INNER join `ep`.`ep_user` e on d.user_id = e.`user_id` where d.settle_month in (202310, 202311, 202312) group by salesmonth ) b on a.salesmonth = b.salesmonth left join `user` `u` on `a`.`sales_id` = `u`.`id` ``` ``` SELECT `m`.`server_id` AS '商家id', `i`.`merch_id` AS '碼商id', `i`.`mini_app_id` AS '小程序id', `i`.`mini_app_name` AS '小程序名稱' FROM `mini_info` `i` LEFT JOIN `code_merch` `m` ON `m`.`id` = `i`.`merch_id` WHERE `i`.`id` NOT IN ( SELECT `mini_info_id` AS 'mini_info_id' FROM ( SELECT `i`.`id` AS `mini_info_id`, `m`.`server_id` AS 'server_id', `m`.`id` AS 'merch_id', `m`.`name` AS 'merch_name', count( `o`.`order_id` ) AS 'count_order_num' FROM `mini_order_notify` `n` LEFT JOIN `mini_info` `i` ON i.mini_app_id = n.mini_app_id LEFT JOIN `mini_template_info` `t` ON t.template_id = i.template_id LEFT JOIN `code_merch` `m` ON m.id = `i`.`merch_id` LEFT JOIN `v3_order` `o` ON `m`.`server_id` = `o`.`server_id` WHERE ( `i`.`merch_id` IS NOT NULL AND `i`.`merch_id` != '' ) AND `o`.`created_at` BETWEEN UNIX_TIMESTAMP( CONCAT( '2023-12', '-01 00:00:00' ) ) AND UNIX_TIMESTAMP( CONCAT( '2024-01', '-16 23:59:59' ) ) AND `o`.`order_status` BETWEEN 2 AND 20 GROUP BY `m`.`server_id` ) a ) AND ( `i`.`merch_id` IS NOT NULL AND `i`.`merch_id` != '' ) SELECT `server_id` AS '商家id', `merch_id` AS '碼商id', `merch_name` AS '碼商商家名稱', `count_order_num` AS '商家訂單數量合計' FROM ( SELECT `m`.`server_id` AS 'server_id', `m`.`id` AS 'merch_id', `m`.`name` AS 'merch_name', count( `o`.`order_id` ) AS 'count_order_num' FROM `mini_order_notify` `n` LEFT JOIN `mini_info` `i` ON i.mini_app_id = n.mini_app_id LEFT JOIN `mini_template_info` `t` ON t.template_id = i.template_id LEFT JOIN `code_merch` `m` ON m.id = `i`.`merch_id` LEFT JOIN `v3_order` `o` ON `m`.`server_id` = `o`.`server_id` LEFT JOIN `tbl_server_info` `tsi` ON `tsi`.`server_id` = `o`.`server_id` WHERE ( `i`.`merch_id` IS NOT NULL AND `i`.`merch_id` != '' ) AND `o`.`created_at` BETWEEN UNIX_TIMESTAMP( CONCAT( '2023-12', '-01 00:00:00' ) ) AND UNIX_TIMESTAMP( CONCAT( '2024-01', '-16 23:59:59' ) ) AND `o`.`order_status` BETWEEN 2 AND 20 -- 剔除關店店鋪 AND `tsi`.`status` = 20 GROUP BY `m`.`server_id` ) a ORDER BY `count_order_num` DESC ``` ``` select s.sales_id as '銷售id', du.dd_name as '銷售名稱', du.dd_mobile as '手機號', u.phone as '系統手機號', u.username as '系統用戶名', t.dept_name as '部門名稱', du.occupation_name as '崗位名稱', count(s.order_id) as '訂單數', group_concat(s.order_id) as '訂單合集' from sales_perform_order_bind s inner join v3_order o on s.order_id = o.order_id inner join `zulin_partition_4`.v3_order_ext po on s.order_id = po.order_id LEFT JOIN `user` u on s.sales_id = u.`id` LEFT JOIN `dingtalk_admin_user` au on au.admin_id = s.`sales_id` LEFT JOIN `dingtalk_user` du on au.user_id = du.id LEFT JOIN `dingtalk_department` t on du.dd_dept_id_list = t.id WHERE `s`.`order_id` BETWEEN 2024050100000000 and 2024060100000000 and o.`order_status` BETWEEN 2 and 20 and po.city = t.city GROUP BY s.`sales_id` ``` ``` SELECT s.sales_id AS '銷售id', du.dd_name AS '銷售名稱', du.dd_mobile AS '手機號', u.phone AS '系統手機號', u.username AS '系統用戶名', t.dept_name AS '部門名稱', du.occupation_name AS '崗位名稱', c.name as '二級標記', c1.name as '一級標記', sum(s.`new_amount`) as '業績', count(s.order_id) AS '訂單數', group_concat(s.order_id) AS '訂單合集' FROM `sales_perform_bind_order_settled_detail` s INNER JOIN v3_order o ON s.order_id = o.order_id LEFT JOIN `user` u ON s.sales_id = u.`id` LEFT JOIN `dingtalk_admin_user` au ON au.admin_id = s.`sales_id` LEFT JOIN `dingtalk_user` du ON au.user_id = du.id LEFT JOIN `dingtalk_department` t ON du.dd_dept_id_list = t.id left join `product`.`sales_tag` `st` on `st`.`object_id` = `o`.`item_id` left join `product`.`tag` `c` on `c`.`id` = `st`.`tag_id` left join `product`.`tag` `c1` on `c1`.`id` = `c`.`pid` WHERE `s`.`order_id` BETWEEN 2024080100000000 AND 2024090100000000 AND o.`order_status` BETWEEN 2 AND 20 and `st`.`type` = 2 AND t.dept_name = '企業銷售五部' GROUP BY s.`sales_id`, c.name, c1.name ``` ``` -- 抖音微企租賬號接待留資-運營取數 SELECT o.order_id as '訂單號', o.phone as '手機號', o.user_id as '用戶id', o.server_id as '商家id', o.item_id as '商品id', DATE_FORMAT( FROM_UNIXTIME(o.time_start), '%Y-%m-%d %H:%i' ) as '租期(開始時間)', DATE_FORMAT( FROM_UNIXTIME(o.time_end), '%Y-%m-%d %H:%i' ) as '租期(結束時間)', o.rental_money as '訂單總租金', o.rental_need_pay as '需付租金', CASE o.order_status WHEN '1' THEN '待付款' WHEN '2' THEN '待發貨' WHEN '3' THEN '待收貨' WHEN '4' THEN '待歸還' WHEN '5' THEN '歸還中' WHEN '6' THEN '已歸還' WHEN '7' THEN '待風控' WHEN '10' THEN '等待服務中' WHEN '13' THEN '正在租賃中(未確認)' WHEN '14' THEN '正在租賃中(已確認轉租金)' WHEN '17' THEN '申請退押中' WHEN '18' THEN '退款中' WHEN '19' THEN '已買斷' WHEN '20' THEN '交易完成' WHEN '21' THEN '訂單關閉(用戶)' WHEN '22' THEN '訂單關閉(租賃商)' WHEN '23' THEN '訂單關閉(系統)' WHEN '24' THEN '訂單關閉(已退款)' WHEN '30' THEN '已刪除' ELSE '未知' END '狀態', CASE WHEN JSON_EXTRACT(ro.report_json, '$.result_info') IS NOT NULL THEN JSON_UNQUOTE(JSON_EXTRACT(ro.report_json, '$.result_info.risk_result.value')) ELSE '空' END as '風控結果' FROM `v3_order` `o` left join `risk_report_order` `ro` on `ro`.`order_id` = `o`.`order_id` WHERE o.phone IN ( 17315063888 ) order by o.phone asc ``` ``` -- 【王乾順】25年03月企業微信群數據導出(剔除企業沒有歷史在租訂單或者完結訂單) select a1.sales_id, a1.dd_name, a1.dd_mobile, a1.wc_account, GROUP_CONCAT(concat(a1.`ep_name`, '(', FROM_UNIXTIME(a1.`auth_complete_time`) ,')')) as 'ep_group', a1.sum_money, a1.order_group, a1.is_pull_group, a1.group_name, a1.group_created_at, a1.we_group_created_month from ( select osd.sales_id as 'sales_id', du.dd_name as 'dd_name', du.dd_mobile as 'dd_mobile', ew_user.wc_account as 'wc_account', `ei`.`ep_name` as 'ep_name', `ei`.`auth_complete_time` as `auth_complete_time`, sum(`osd`.`new_amount`) as 'sum_money', GROUP_CONCAT( concat(`osd`.`order_id`, '(', `osd`.`new_amount`, ')') ) as 'order_group', case when ew_g.group_id is not null then '是' else '' end as 'is_pull_group', ew_g.group_name, `ew_g`.`group_created_at`, case when `ew_g`.`group_created_at` != 0 then FROM_UNIXTIME(`ew_g`.`group_created_at`, '%Y-%m') else '' end AS 'we_group_created_month' from `zulin`.`sales_perform_bind_order_settled_detail` `osd` inner join `zulin`.`v3_order` `o` on `o`.`order_id` = `osd`.`order_id` -- 企微群信息(開始) inner join `zulin`.`ep_wechat_admin_user` `ew_au` on `ew_au`.`admin_id` = `osd`.`sales_id` left join `zulin`.`ep_wechat_user` `ew_user` on `ew_user`.`id` = `ew_au`.`user_id` left join `ep`.`ep_wechat_customer_group_member` `ew_gm` on `ew_gm`.`user_id` = `ew_user`.`wc_account` left join `ep`.`ep_wechat_customer_group` `ew_g` on `ew_g`.`group_id` = `ew_gm`.`group_id` -- 企微群信息(結束) -- 銷售信息(開始) LEFT JOIN `zulin`.`dingtalk_admin_user` `au` on `au`.`admin_id` = `osd`.`sales_id` LEFT JOIN `zulin`.`dingtalk_user` `du` on `au`.`user_id` = `du`.`id` LEFT JOIN `zulin`.`dingtalk_department` `dt` on `du`.`dd_dept_id_list` = `dt`.`id` -- 銷售信息(結束) -- 企業信息(開始) left join `ep`.`ep_manager` `epm` on `epm`.`sales_id` = `osd`.`sales_id` left join `ep`.`ep_info` `ei` on `ei`.`id` = `epm`.`ep_id` -- 企業信息(結束) where `osd`.`settle_month` in (202411) and `ei`.`auth_complete_time` BETWEEN UNIX_TIMESTAMP(CONCAT('2024-11', '-01 00:00:00')) AND UNIX_TIMESTAMP(CONCAT('2024-11', '-30 23:59:59')) and `ei`.`status` = 1 and `epm`.`sales_id` IS NOT NULL GROUP BY `ei`.`id` order by osd.sales_id asc ) a1 group BY a1.sales_id ``` ``` --- 【王乾順】25年3月開票數據集導出(業務:趙海豐、劉玉航) SELECT `ui`.`order_id` AS '訂單號', `ui`.`user_id` AS '用戶id', `u`.`username` as '用戶名稱', `ui`.`server_id` AS '商家id', `ui`.`company` AS '商家店鋪', t.dept_name as '銷售部門', du.dd_name as '銷售名稱', from_unixtime(uiml.`created_at`) as '申請時間', uiml.`created_by` as '申請人id', u1.username as '申請人名稱', case when `ui`.`first_finish_at` != 0 then from_unixtime(`ui`.`first_finish_at`) else '' end as '開票時間', `ui`.`this_invoice` AS '本次開票金額', `ui`.`has_invoice` AS '已開票金額', `ui`.`this_invoice_nums` AS '本次開票金額賬單期數集合', `ui`.`has_invoice_nums` AS '已開票金額賬單期數集合', CASE `ui`.`mode` WHEN '1' THEN '手動' WHEN '2' THEN '自動' ELSE '未知' END '開票方式', `ui`.`remark` AS '備注', CASE `ui`.`invoice_type` WHEN '1' THEN '電子發票(普通發票)' WHEN '2' THEN '紙質發票' WHEN '3' THEN '電子發票(增值稅專用發票)' ELSE '未知' END '發票類型', CASE `ui`.`invoice_status` WHEN '1' THEN '未開票' WHEN '10' THEN '已開票' WHEN '11' THEN '重開中' WHEN '12' THEN '已重開' WHEN '13' THEN '已作廢' ELSE '未知' END '發票狀態' FROM `user_invoice` `ui` left join `user_invoice_history` `uih` on `uih`.`user_invoice_id` = `ui`.`id` left join `user_invoice_modify_log` `uiml` on `uiml`.`user_invoice_id` = `ui`.`id` left join `user` `u1` on `u1`.`id` = `uiml`.`created_by` left join `user` `u` on `u`.`id` = `ui`.`user_id` left join `sales_order` `so` on `so`.`order_id` = `ui`.`order_id` LEFT JOIN `dingtalk_admin_user` au on au.admin_id = so.`sales_id` LEFT JOIN `dingtalk_user` du on au.user_id = du.id LEFT JOIN `dingtalk_department` t on du.dd_dept_id_list = t.id WHERE `ui`.`created_at` BETWEEN UNIX_TIMESTAMP( CONCAT( '2025-03', '-01 00:00:00' )) AND UNIX_TIMESTAMP( CONCAT( '2025-03', '-31 23:59:59' )) order by `uiml`.`created_at` asc ``` ``` SELECT JSON_EXTRACT(`form_data`, '$."公司名稱"') as 'c', JSON_EXTRACT(`form_data`, '$."聯系方式"') as 'p', from_unixtime(`created_at`) as 't' FROM `v2_h5_application_form_data` WHERE `form_id` IN (25, 26, 27) ORDER BY `created_at` desc ```
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看