SampleTest.java 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326
  1. package org.jeecg;
  2. import cn.com.ctop.bytedance.service.IReportService;
  3. import cn.com.ctop.common.module.entity.CtopOauthToken;
  4. import cn.com.ctop.common.module.mapper.CtopOauthTokenMapper;
  5. import cn.com.ctop.common.module.service.ICtopOauthTokenService;
  6. import cn.com.ctop.common.module.service.IUserAllocationService;
  7. import cn.com.ctop.common.module.utils.CtopAdConstant;
  8. import cn.com.ctop.common.module.utils.HttpUtils;
  9. import cn.com.ctop.common.module.utils.OSSUtils;
  10. import cn.com.ctop.kuaishou.modules.batch.service.IKuaiShouCreativeService;
  11. import cn.com.ctop.kuaishou.modules.batch.service.IKuaiShouHistoryReportTaskService;
  12. import cn.com.ctop.kuaishou.modules.batch.service.IKuaishouInterfaceService;
  13. import cn.com.ctop.toutiao.service.IByteDanceAdvertiserDataService;
  14. import com.alibaba.fastjson.JSONArray;
  15. import com.alibaba.fastjson.JSONObject;
  16. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
  17. import lombok.extern.slf4j.Slf4j;
  18. import org.jeecg.common.util.DateUtils;
  19. import org.jeecg.modules.ctop.service.IBytedanceFundDailyService;
  20. import org.jeecg.modules.ctop.service.IPerformanceSaleService;
  21. import org.junit.Test;
  22. import org.junit.runner.RunWith;
  23. import org.springframework.beans.factory.annotation.Autowired;
  24. import org.springframework.boot.test.context.SpringBootTest;
  25. import org.springframework.test.context.junit4.SpringRunner;
  26. import java.io.FileInputStream;
  27. import java.io.InputStream;
  28. import java.text.SimpleDateFormat;
  29. import java.util.ArrayList;
  30. import java.util.Date;
  31. import java.util.List;
  32. import java.util.concurrent.CountDownLatch;
  33. import java.util.concurrent.ExecutorService;
  34. import java.util.concurrent.Executors;
  35. @RunWith(SpringRunner.class)
  36. @SpringBootTest
  37. @Slf4j
  38. public class SampleTest {
  39. @Autowired
  40. private IKuaishouInterfaceService kuaishouInterfaceService;
  41. @Autowired
  42. private IKuaiShouHistoryReportTaskService reportTaskService;
  43. @Autowired
  44. private CtopOauthTokenMapper tokenMapper;
  45. @Test
  46. public void kuaisShouReport() {
  47. try {
  48. QueryWrapper<CtopOauthToken> queryWrapper = new QueryWrapper<>();
  49. queryWrapper.eq("account_id", 3727345L);
  50. CtopOauthToken token = tokenMapper.selectOne(queryWrapper);
  51. SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");
  52. Date parse = simpleDateFormat.parse("2020-03-12");
  53. kuaishouInterfaceService.getAdvertiserReportDaily(token, parse, parse);
  54. // reportTaskService.createTask(3727345L, "871fc2c248782a94ad2962c941555abc", "");
  55. // reportTaskService.getTaskList();
  56. /*
  57. reportTaskService.createTask(3727345L, "871fc2c248782a94ad2962c941555abc");
  58. reportTaskService.getTaskList();*/
  59. /* String url = "https://ad.e.kuaishou.com/rest/openapi/v1/async_task/list";
  60. Map<String, String> headers = new HashMap<>();
  61. headers.put("Content-Type", " application/json");
  62. headers.put("Access-Token", "eb9a0d18072eabc339ee26ad010ecd6b");
  63. JSONObject param = new JSONObject();
  64. param.put("advertiser_id", 142402);
  65. JSONArray taskIds = new JSONArray();
  66. taskIds.add(1229917);
  67. param.put("task_ids", taskIds);
  68. String result = HttpUtils.kuaiShouhttpPostRequest(url, param.toJSONString(), headers);
  69. JSONObject resultJson = JSONObject.parseObject(result);
  70. /* String url = "https://ad.e.kuaishou.com/rest/openapi/v1/async_task/download";
  71. Map<String, String> headers = new HashMap<>();
  72. headers.put("Access-Token", "eb9a0d18072eabc339ee26ad010ecd6b");
  73. Map<String,Object> param = new HashMap<>();
  74. param.put("advertiser_id", 142402);
  75. param.put("task_id", "1229917");
  76. String result = HttpUtils.KuaiShouttpGetRequest(url, param,headers);*/
  77. /*URL url = new URL("https://ad.e.kuaishou.com/rest/openapi/v1/async_task/download?task_id=1229917&advertiser_id=142402");
  78. HttpURLConnection conn = (HttpURLConnection) url.openConnection();
  79. //设置超时间为3秒
  80. conn.setConnectTimeout(10 * 1000);
  81. //防止屏蔽程序抓取而返回403错误
  82. conn.setRequestProperty("User-Agent", "Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)");
  83. conn.setRequestProperty("Access-Token", "6a1fbe20e49fe519ec8120aac5c9e55a");
  84. //得到输入流
  85. InputStream inputStream = conn.getInputStream();
  86. //获取自己数组
  87. byte[] getData = readInputStream(inputStream);
  88. //文件保存位置
  89. File saveDir = new File("D:\\file");
  90. if (!saveDir.exists()) {
  91. saveDir.mkdirs();
  92. }
  93. String fileName = "123.csv";
  94. File file = new File(saveDir + File.separator + fileName);
  95. FileOutputStream fos = new FileOutputStream(file);
  96. fos.write(getData);
  97. if (fos != null) {
  98. fos.close();
  99. }
  100. if (inputStream != null) {
  101. inputStream.close();
  102. }*/
  103. /* String localPath = "D:\\file\\123.csv";
  104. reportDailyAccountMapper.loadAccountDailyReport(142402L,localPath);*/
  105. } catch (Exception e) {
  106. e.printStackTrace();
  107. }
  108. }
  109. @Autowired
  110. private ICtopOauthTokenService tokenService;
  111. private static ExecutorService executorService = Executors.newFixedThreadPool(10);
  112. private static CountDownLatch countDownLatch = null;
  113. @Autowired
  114. private IBytedanceFundDailyService fundDailyService;
  115. @Test
  116. public void testLoadJob() {
  117. String endDate = "2020-04-07";
  118. String startDate = "2019-09-01";
  119. CtopOauthToken token = tokenService.getTokenByAccountId(1654676647522317L);
  120. // List<CtopOauthToken> tokens = tokenService.getTokenListByType(CtopAdConstant.PLATFORM_TYPE_BYTEDANCE);
  121. List<CtopOauthToken> tokens = new ArrayList<>();
  122. tokens.add(token);
  123. if (null != tokens && tokens.size() > 0) {
  124. countDownLatch = new CountDownLatch(tokens.size());
  125. tokens.forEach(getToken -> {
  126. //拉取往期数据
  127. executorService.submit(new Runnable() {
  128. @Override
  129. public void run() {
  130. try {
  131. fundDailyService.loadFundDataByPage(getToken, startDate, endDate, 1);
  132. countDownLatch.countDown();
  133. } catch (Exception e) {
  134. e.printStackTrace();
  135. }
  136. }
  137. });
  138. });
  139. try {
  140. countDownLatch.await();
  141. System.out.println("数据获取完成");
  142. } catch (InterruptedException e) {
  143. e.printStackTrace();
  144. }
  145. }
  146. }
  147. @Test
  148. public void loadCampaignDate() {
  149. Date endDate = DateUtils.addDay(new Date(), -1);
  150. Date startDate = DateUtils.addDay(new Date(), -10);
  151. //1:查询当日数据
  152. List<CtopOauthToken> tokens = tokenService.getTokenListByType(CtopAdConstant.PLATFORM_TYPE_BYTEDANCE);
  153. if (null == tokens || tokens.size() <= 0) {
  154. log.info("定时获取头条数据异常:为获取到可用的token");
  155. return;
  156. }
  157. // executorService = Executors.newFixedThreadPool(10);
  158. tokens.forEach(token -> {
  159. // executorService.submit(new Runnable() {
  160. // @Override
  161. // public void run() {
  162. //获取广告主信息数据
  163. reportService.getCampaignReportByPage(token, startDate, endDate, CtopAdConstant.BYTEDANCE_REPORT_TYPE_DAILY, 1);
  164. // }
  165. // });
  166. });
  167. }
  168. @Autowired
  169. private IReportService reportService;
  170. @Autowired
  171. private IUserAllocationService userAllocationService;
  172. @Test
  173. public void wanHuaTong() {
  174. String url = "https://ad.oceanengine.com/open_api/2/kaleidoscope/job/smart_cut/submit/";
  175. JSONObject conditions = new JSONObject();
  176. // 1629785592929294
  177. conditions.put("advertiser_id", "1659671533108238");
  178. JSONObject job = new JSONObject();
  179. job.put("job_conf_id", 10);
  180. JSONArray input = new JSONArray();
  181. JSONObject inputJson = new JSONObject();
  182. inputJson.put("task_id", 1);
  183. JSONArray videoIds = new JSONArray();
  184. videoIds.add("v02033aa0000bpspgippskdk4jcuso80");
  185. inputJson.put("video_ids", videoIds);
  186. JSONArray music_id = new JSONArray();
  187. JSONArray image_urls = new JSONArray();
  188. JSONArray texts = new JSONArray();
  189. texts.add("哈哈哈哈,这是一个测试文案");
  190. inputJson.put("texts", texts);
  191. JSONArray tts = new JSONArray();
  192. tts.add("true");
  193. inputJson.put("tts", tts);
  194. JSONArray video_ratio = new JSONArray();
  195. video_ratio.add("1");
  196. inputJson.put("video_ratio", video_ratio);
  197. JSONArray music_style = new JSONArray();
  198. music_style.add("1");
  199. inputJson.put("music_style", music_style);
  200. JSONArray video_duration = new JSONArray();
  201. video_duration.add("8");
  202. inputJson.put("video_duration", video_duration);
  203. JSONArray speed = new JSONArray();
  204. speed.add("1.2");
  205. inputJson.put("speed", speed);
  206. job.put("input", inputJson);
  207. job.put("mesg", "测试万花筒");
  208. conditions.put("job", job);
  209. JSONObject jsonObject = HttpUtils.bytedancePostRequest("f925c180e05d585f7a9fce048ba62eecc5dab7c2", url, conditions);
  210. System.err.println(jsonObject);
  211. }
  212. @Autowired
  213. private IKuaiShouCreativeService creativeService;
  214. @Test
  215. public void testSalePerformance() {
  216. performanceSaleService.loadSalsePerformance();
  217. }
  218. @Test
  219. public void loadBtPlanData() {
  220. List<CtopOauthToken> tokens = tokenService.getTokenListByType(CtopAdConstant.PLATFORM_TYPE_BYTEDANCE);
  221. tokens.forEach(token -> {
  222. advertiserDataService.getAdvertiserPlan(token, "", null, null);
  223. });
  224. }
  225. @Autowired
  226. private IByteDanceAdvertiserDataService advertiserDataService;
  227. @Autowired
  228. private IPerformanceSaleService performanceSaleService;
  229. @Autowired
  230. private IKuaiShouHistoryReportTaskService historyReportTaskService;
  231. @Test
  232. public void testLoadData() throws Exception {
  233. CtopOauthToken token = tokenService.getTokenByAccountId(5473041L);
  234. String endDateStr = DateUtils.getDate("yyyy-MM-dd");
  235. String startDate = DateUtils.addMonth(endDateStr, -6);
  236. historyReportTaskService.createTask(token.getAccountId(), token.getAccessToken(), startDate, endDateStr, CtopAdConstant.KUAISHOU_LOAD_JOB_TYPE_HISTORY);
  237. }
  238. @Test
  239. public void suZhao() {
  240. Long accountId = 3917130L;
  241. String token = "0a42e23921e486108105263e75561404";
  242. kuaishouInterfaceService.getVideoList("e91c778d7de1bd0e9d8f3213d1e0e57c",3820093L, null,null,1);
  243. }
  244. @Test
  245. public void test() throws Exception {
  246. InputStream file = new FileInputStream("D:\\data\\模板视频\\原始模板4.mp4");
  247. OSSUtils.uploadFile2OSS(file, "/model/video/", "123.mp4");
  248. }
  249. }