# 会员卡到期取消分销商
> 修改文件
```
<pre class="calibre13">```
<span class="token4">// 在该文件的 index_info() 方法中调用 新增的 update_member() 方法</span>
<span class="token4">// index_info 小程序首页加载时会访问该方法</span>
<span class="token2">/</span>Modules<span class="token2">/</span>Home<span class="token2">/</span>Controller<span class="token2">/</span>IndexController<span class="token1">.</span>class<span class="token1">.</span>php
```
```
```
<pre class="calibre6">```
<span class="token4">/**
* 会员卡到期后取消其分销商
*/</span>
public <span class="token6">function</span> <span class="token3">update_member</span><span class="token1">(</span><span class="token1">)</span>
<span class="token1">{</span>
####################### 新增内容 start #######################
<span class="token4">// 查询会员卡到期的会员 返回空数组或二维数组</span>
$data <span class="token2">=</span> <span class="token3">M</span><span class="token1">(</span><span class="token1">)</span><span class="token2">-</span><span class="token2">></span><span class="token3">query</span><span class="token1">(</span><span class="token5">'SELECT * FROM '</span> <span class="token1">.</span> <span class="token3">C</span><span class="token1">(</span><span class="token5">'DB_PREFIX'</span><span class="token1">)</span> <span class="token1">.</span> <span class="token5">'lionfish_comshop_member WHERE comsiss_flag = 1 AND card_end_time < '</span> <span class="token1">.</span> <span class="token3">time</span><span class="token1">(</span><span class="token1">)</span><span class="token1">)</span><span class="token1">;</span>
<span class="token6">if</span> <span class="token1">(</span>$data<span class="token1">)</span> <span class="token1">{</span>
<span class="token4">// 会员卡到期后取消其分销商</span>
$upData <span class="token2">=</span> <span class="token1">[</span>
<span class="token4">// 是否是分销商 1 是 0 不是</span>
<span class="token5">'comsiss_flag'</span> <span class="token2">=</span><span class="token2">></span> <span class="token">0</span><span class="token1">,</span>
<span class="token4">// 分销商状态 1 审核 0 未审核</span>
<span class="token5">'comsiss_state'</span> <span class="token2">=</span><span class="token2">></span> <span class="token">0</span><span class="token1">,</span>
<span class="token4">// 成为分销商的时间</span>
<span class="token5">'comsiss_time'</span> <span class="token2">=</span><span class="token2">></span> <span class="token5">''</span><span class="token1">,</span>
<span class="token1">]</span><span class="token1">;</span>
foreach <span class="token1">(</span>$data as $v<span class="token1">)</span> <span class="token1">{</span>
<span class="token3">M</span><span class="token1">(</span><span class="token5">'lionfish_comshop_member'</span><span class="token1">)</span>
<span class="token2">-</span><span class="token2">></span><span class="token3">where</span><span class="token1">(</span><span class="token3">array</span><span class="token1">(</span><span class="token5">'member_id'</span> <span class="token2">=</span><span class="token2">></span> $v<span class="token1">[</span><span class="token5">'member_id'</span><span class="token1">]</span><span class="token1">)</span><span class="token1">)</span>
<span class="token2">-</span><span class="token2">></span><span class="token3">save</span><span class="token1">(</span>$upData<span class="token1">)</span><span class="token1">;</span>
<span class="token1">}</span>
<span class="token1">}</span>
####################### 新增内容 end #######################
<span class="token1">}</span>
```
```
