{
 "cells": [
  {
   "metadata": {},
   "cell_type": "markdown",
   "source": "# 材料分类新增",
   "id": "24450285119edffc"
  },
  {
   "cell_type": "code",
   "id": "initial_id",
   "metadata": {
    "collapsed": true,
    "ExecuteTime": {
     "end_time": "2026-03-03T03:05:10.661554200Z",
     "start_time": "2026-03-03T03:05:10.192818600Z"
    }
   },
   "source": [
    "import requests\n",
    "import pandas as pd\n",
    "cookies = {\n",
    "    'f6-ids-goodsSESSIONID': 'bdf9d5f3-4ef8-4877-ba8b-621b10eba091',\n",
    "    'erpLanguage': 'zh-CN',\n",
    "    'tmall': 'false',\n",
    "    'prodOrg': '11240984669917217520',\n",
    "    'unp': '15865484595890778191',\n",
    "    '_up': '-NillNN-qyBEJ--t3vnSknvoOF53y_SJuMkA2n43U-daUfnArpjQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqE_ERqYsr3gUN9_NRv-ZNHu3M-GTc1p60EX-sq-RQgeIal1HLPxpurEj9nxTH98zEYGg.',\n",
    "    'sensorsdata2015jssdkcross': '%7B%22distinct_id%22%3A%2215865484595890778191%22%2C%22first_id%22%3A%2219b6df76a22f46-04a98afdd2a11d8-4c657b58-1327104-19b6df76a2312c7%22%2C%22props%22%3A%7B%22%24latest_traffic_source_type%22%3A%22%E7%9B%B4%E6%8E%A5%E6%B5%81%E9%87%8F%22%2C%22%24latest_search_keyword%22%3A%22%E6%9C%AA%E5%8F%96%E5%88%B0%E5%80%BC_%E7%9B%B4%E6%8E%A5%E6%89%93%E5%BC%80%22%2C%22%24latest_referrer%22%3A%22%22%7D%2C%22%24device_id%22%3A%2219b6df76a22f46-04a98afdd2a11d8-4c657b58-1327104-19b6df76a2312c7%22%7D',\n",
    "}\n",
    "\n",
    "headers = {\n",
    "    'accept': 'application/json, text/plain, */*',\n",
    "    'accept-language': 'zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6',\n",
    "    'content-type': 'application/json;charset=UTF-8',\n",
    "    'origin': 'https://ids-goods.f6car.cn',\n",
    "    'priority': 'u=1, i',\n",
    "    'referer': 'https://ids-goods.f6car.cn/f6-ids-goods/view/material.html',\n",
    "    'sec-ch-ua': '\"Not:A-Brand\";v=\"99\", \"Microsoft Edge\";v=\"145\", \"Chromium\";v=\"145\"',\n",
    "    'sec-ch-ua-mobile': '?0',\n",
    "    'sec-ch-ua-platform': '\"Windows\"',\n",
    "    'sec-fetch-dest': 'empty',\n",
    "    'sec-fetch-mode': 'cors',\n",
    "    'sec-fetch-site': 'same-origin',\n",
    "    'user-agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36 Edg/145.0.0.0',\n",
    "    # 'cookie': 'f6-ids-goodsSESSIONID=bdf9d5f3-4ef8-4877-ba8b-621b10eba091; erpLanguage=zh-CN; tmall=false; prodOrg=11240984669917217520; unp=15865484595890778191; _up=-NillNN-qyBEJ--t3vnSknvoOF53y_SJuMkA2n43U-daUfnArpjQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqE_ERqYsr3gUN9_NRv-ZNHu3M-GTc1p60EX-sq-RQgeIal1HLPxpurEj9nxTH98zEYGg.; sensorsdata2015jssdkcross=%7B%22distinct_id%22%3A%2215865484595890778191%22%2C%22first_id%22%3A%2219b6df76a22f46-04a98afdd2a11d8-4c657b58-1327104-19b6df76a2312c7%22%2C%22props%22%3A%7B%22%24latest_traffic_source_type%22%3A%22%E7%9B%B4%E6%8E%A5%E6%B5%81%E9%87%8F%22%2C%22%24latest_search_keyword%22%3A%22%E6%9C%AA%E5%8F%96%E5%88%B0%E5%80%BC_%E7%9B%B4%E6%8E%A5%E6%89%93%E5%BC%80%22%2C%22%24latest_referrer%22%3A%22%22%7D%2C%22%24device_id%22%3A%2219b6df76a22f46-04a98afdd2a11d8-4c657b58-1327104-19b6df76a2312c7%22%7D',\n",
    "}\n",
    "df = pd.read(fr\"C:\\Users\\hp_z66\\OneDrive\\Desktop\\钉钉文件\\新建 XLS 工作表.xls\",sheet_name='Sheet1')\n",
    "for index, row in df.iterrows():\n",
    "    print(f\"正在创建材料一级分类{df[\"上级分类名称\"]}\")\n",
    "    json_data = {\n",
    "        'partCategory': {\n",
    "            'categoryLevel': 1,\n",
    "            'name': df[\"上级分类名称\"],\n",
    "            'pId': '14438164991364920807',\n",
    "            'sort': 999,\n",
    "            'kzId': '',\n",
    "        },\n",
    "    }\n",
    "\n",
    "    response = requests.post(\n",
    "        'https://ids-goods.f6car.cn/f6-ids-goods/part/category/add',\n",
    "        cookies=cookies,\n",
    "        headers=headers,\n",
    "        json=json_data,\n",
    "    )\n",
    "\n",
    "    pkId = response.json().get(\"data\").get(\"pkId\")\n",
    "    print(f\"正在创建材料2级分类{df[\"分类名称\"]}\")\n",
    "    json_data = {\n",
    "    'partCategory': {\n",
    "        'categoryLevel': 2,\n",
    "        'name': df[\"分类名称\"],\n",
    "        'sort': '',\n",
    "        'pId': pkId,\n",
    "        'idFrom': '',\n",
    "        'kzId': '',\n",
    "    },\n",
    "    }\n",
    "\n",
    "    response = requests.post(\n",
    "        'https://ids-goods.f6car.cn/f6-ids-goods/part/category/add',\n",
    "        cookies=cookies,\n",
    "        headers=headers,\n",
    "        json=json_data,\n",
    "    )\n",
    "    print(\"材料二级分类完成\")"
   ],
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'code': 200,\n",
       " 'data': {'categoryLevel': 1,\n",
       "  'code': '',\n",
       "  'creationtime': 1772507110598,\n",
       "  'creator': '15865484595890778191',\n",
       "  'groupId': None,\n",
       "  'href': '',\n",
       "  'id': None,\n",
       "  'idFrom': None,\n",
       "  'idMaintainType': '0',\n",
       "  'idOwnOrg': '11240984669917217520',\n",
       "  'isDel': 0,\n",
       "  'kzId': '',\n",
       "  'manageStatus': None,\n",
       "  'modifiedtime': 1772507110598,\n",
       "  'modifier': '15865484595890778191',\n",
       "  'name': '23',\n",
       "  'nodes': None,\n",
       "  'pId': '14438164991364920807',\n",
       "  'parentName': '',\n",
       "  'partPriceRuleId': None,\n",
       "  'pkId': '14582097883198654339',\n",
       "  'queryFlag': None,\n",
       "  'sort': 999,\n",
       "  'text': ''},\n",
       " 'message': 'SUCCESS'}"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "execution_count": 3
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}