leo493852107

-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: 2022-12-08 14:00:24
-- 服务器版本： 10.1.19-MariaDB
-- B站 https://www.bilibili.com/video/BV1j5411o7xH/
-- PHP Version: 5.6.28

leo493852107

# Host: localhost  (Version 5.7.19-log)
# Date: 2022-06-13 10:04:40
# Generator: MySQL-Front 6.1  (Build 1.26)

CREATE DATABASE `guigu-auth` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
use `guigu-auth`;

#
# Structure for table "sys_dept"
#

leo493852107

#!/usr/bin/env python
# -*- coding: utf-8 -*-
# 股票盈利计算， 默认佣金按万2.5算

print ('================== 默认佣金为万2.5 ==================')

# 佣金比率 万2.5
commission = 0.00025

buy_count = raw_input('请输入购买的数量:')

leo493852107

mysql -h127.0.0.1 -uroot -p --default-character-set=utf8 -e "SELECT customer_customer.short_name, sale_planorderitem.* FROM sale_planorder INNER JOIN customer_customer ON sale_planorder.customer_id=customer_customer.id INNER JOIN sale_planorderitem ON sale_planorderitem.order_id=sale_planorder.id
WHERE customer_customer.short_name='客户名称' AND sale_planorder.add_time>='2019-08-01 00:00:00' AND sale_planorder.add_time<='2019-10-01 00:00:00' ORDER BY sale_planorder.add_time;" hey_star_crm > /Users/leo/Downloads/test.xls

leo493852107

UPDATE sale_planorderitem a 
INNER JOIN 
(SELECT b.id FROM sale_planorder b, customer_customer c WHERE c.short_name='客户名称' AND b.customer_id=c.id AND b.add_time>='2019-08-01 00:00:00' AND b.add_time<='2019-10-01 00:00:00') as t
ON a.order_id=t.id SET a.total_price=a.unit_price*a.quantity 

leo493852107

SELECT customer_customer.short_name, sale_planorderitem.* FROM sale_planorder INNER JOIN customer_customer ON sale_planorder.customer_id=customer_customer.id INNER JOIN sale_planorderitem ON sale_planorderitem.order_id=sale_planorder.id
WHERE customer_customer.short_name='客户名称' AND sale_planorder.add_time>='2019-08-01 00:00:00' AND sale_planorder.add_time<='2019-10-01 00:00:00' ORDER BY sale_planorder.add_time;

leo493852107

#!/usr/bin/env python
# -*- coding: utf-8 -*-

__author__ = "leo"
__time__ = "2019-03-04"

import os
import requests

leo493852107

# 参考 用python的win32com模块替换word中的文字搞定批量打印奖状
# 

# -*- coding: utf-8-*-

import win32com
from win32com.client import Dispatch, constants

#模板文件保存路径，此处使用的是绝对路径，相对路径未测试过
template_path = 'C:\Users\yely\Desktop\jiangzhuang\print.doc'

leo493852107

UPDATE reference_country set id=replace(uuid(),'-','');

leo493852107

#!/usr/bin/env python
# -*- coding: utf-8 -*-

__author__ = "leo"
__time__ = "2018-09-09"

import base64
import requests