source: temp/test-xoops.ec-cube.net/data/lib/admin_slib.php @ 1143

Revision 1143, 4.5 KB checked in by kakinaka, 19 years ago (diff)
Line 
1<?php
2/*
3    ´ÉÍý²èÌÌÀìÍѥ饤¥Ö¥é¥ê
4*/
5
6/* ¾¦Éʤò¥«¥Æ¥´¥êÀèƬ¤ËÄɲà */
7function sfProductAddTopCat($category_id, $product_id) {
8    // ºÇ¾å°Ì¥«¥Æ¥´¥ê¤ò¼èÆÀ¤¹¤ë
9    $root_category_id = sfGetRootParentID("dtb_category", "parent_category_id", "category_id", $category_id);
10    $sqlval['category_id'] = $category_id;
11    $sqlval['root_category_id'] = $root_category_id;
12    $sqlval['product_id'] = $product_id;
13    $objQuery = new SC_Query();
14    // ºÇ¾å°Ì¥é¥ó¥¯
15    $sqlval['rank'] = $objQuery->max("dtb_products_category", "rank", "root_category_id = ?", array($root_category_id)) + 1;
16    $objQuery->insert("dtb_products_category", $sqlval);
17}
18
19/* ¾¦Éʤò¥«¥Æ¥´¥êËöÈø¤ËÄɲà */
20function sfProductAddBottomCat($category_id, $product_id) {
21    // ºÇ¾å°Ì¥«¥Æ¥´¥ê¤ò¼èÆÀ¤¹¤ë
22    $root_category_id = sfGetRootParentID("dtb_category", "parent_category_id", "category_id", $category_id);
23    $sqlval['category_id'] = $category_id;
24    $sqlval['root_category_id'] = $root_category_id;
25    $sqlval['product_id'] = $product_id;
26    // ºÇ²¼°Ì¥é¥ó¥¯
27    $sqlval['rank'] = '1';
28    $objQuery = new SC_Query();
29    // ÅÐÏ¿ºÑ¤ß¥ì¥³¡¼¥É¤Î¥é¥ó¥¯¤ò¾å¤²¤ë
30    $sql = "UPDATE dtb_products_category SET rank = rank + 1 WHERE root_category_id = ?";
31    $objQuery->query($sql, array($root_category_id));
32    $objQuery->insert("dtb_products_category", $sqlval);
33}
34
35/* ¾¦Éʤò¥«¥Æ¥´¥ê¤«¤é³°¤¹ */
36function sfProductRemoveCat($category_id, $product_id) {
37    $objQuery = new SC_Query();
38    $where = "category_id = ? AND product_id = ?";
39    $arrval = array($category_id, $product_id);
40    $arrRet = $objQuery->select("rank", "dtb_products_category", $where, $arrval);
41    foreach($arrRet as $array) {
42        // ¾å°Ì¥é¥ó¥¯¤Î¥ì¥³¡¼¥É¤Î¥é¥ó¥¯¤ò²¼¤²¤ë
43        $sql = "UPDATE dtb_products_category SET rank = rank - 1 WHERE rank > ? AND category_id = ?";
44        $objQuery->query($sql, array($array['rank'], $category_id));
45    }
46    $objQuery->delete("dtb_products_category",$where, $arrval);
47}
48
49/* ¼«Ê¬°Ê³°¤Î¥µ¡¼¥Ð¤Ë¥Õ¥¡¥¤¥ë¤ò¥³¥Ô¡¼¤¹¤ë */
50function sfOtherFtpCopy($src_path, $dst_path) {
51    global $arrWEB_SERVERS;
52    foreach($arrWEB_SERVERS as $array) {
53        if($array['host'] != $_SERVER["SERVER_ADDR"]) {
54            sfFtpCopy($array['host'], $array['user'], $array['pass'], $dst_path, $src_path);           
55        }
56    }   
57}
58
59// FTPÄÌ¿®¤Ç¥Õ¥¡¥¤¥ë¥³¥Ô¡¼¤ò¹Ô¤¦¡£
60/*
61    $host:FTP¥Û¥¹¥È
62    $user:FTP¥æ¡¼¥¶
63    $pass:FTP¥Ñ¥¹¥ï¡¼¥É
64    $dst_file:Á÷¿®Àè¥Õ¥¡¥¤¥ë¡ÊÁêÂХѥ¹¡Ë
65    $src_file:Á÷¿®¸µ¥Õ¥¡¥¤¥ë¡ÊÀäÂХѥ¹¡Ë
66 */
67function sfFtpCopy($host, $user, $pass, $dst_file, $src_file) {
68
69    // FTPÀܳ
70    $conn_id = @ftp_connect($host);
71   
72    // Àܳ³Îǧ
73    if((!$conn_id)) {
74        gfPrintLog("FTPÀܳ¤Ë¼ºÇÔ¤·¤Þ¤·¤¿¡£SERVER:" . $host);
75        return;
76    }
77   
78    // FTP¥í¥°¥¤¥ó
79    $login_result = @ftp_login($conn_id, $user, $pass);
80   
81    if ((!$login_result)) {
82        gfPrintLog("FTP¥í¥°¥¤¥ó¤Ë¼ºÇÔ¤·¤Þ¤·¤¿¡£USER:" . $user . " SERVER:" . $host);
83        return;
84    }
85   
86    // Á÷¿®¸µ¥Õ¥¡¥¤¥ë¤Î¸ºß¥Á¥§¥Ã¥¯
87    if (file_exists($src_file)) {
88        // ¥Õ¥¡¥¤¥ëÁ÷¿®
89        $upload = @ftp_put($conn_id, $dst_file, $src_file, FTP_BINARY);
90    } else {
91        gfPrintLog("FTPÁ÷¿®¸µ¥Õ¥¡¥¤¥ë¤¬¸«¤Ä¤«¤ê¤Þ¤»¤ó¡£" . $src_file);
92        return;
93    }
94
95    // ¥Õ¥¡¥¤¥ë¥¢¥Ã¥×¥í¡¼¥É
96    if (!$upload) {
97        gfPrintLog("¥¢¥Ã¥×¥í¡¼¥É¤Ë¼ºÇÔ¤·¤Þ¤·¤¿¡£SERVER:" . $host . " " . $src_file . " -> " . $dst_file);
98    } else {
99        gfPrintLog("¥¢¥Ã¥×¥í¡¼¥É¤ËÀ®¸ù¤·¤Þ¤·¤¿¡£SERVER:" . $host . " " . $src_file . " -> " . $dst_file);
100    }
101       
102    // Àܳ¤òÊĤ¸¤ë
103    ftp_close($conn_id);
104}
105
106function sfFtpDelete($host, $user, $pass, $dst_file) {
107    // FTPÀܳ
108    $conn_id = @ftp_connect($host);
109   
110    // Àܳ³Îǧ
111    if((!$conn_id)) {
112        gfPrintLog("FTPÀܳ¤Ë¼ºÇÔ¤·¤Þ¤·¤¿¡£SERVER:" . $host);
113        return;
114    }
115   
116    // FTP¥í¥°¥¤¥ó
117    $login_result = @ftp_login($conn_id, $user, $pass);
118   
119    if ((!$login_result)) {
120        gfPrintLog("FTP¥í¥°¥¤¥ó¤Ë¼ºÇÔ¤·¤Þ¤·¤¿¡£USER:" . $user . " SERVER:" . $host);
121        return;
122    }
123       
124    // ¥Õ¥¡¥¤¥ëºï½ü
125    if (@ftp_delete($conn_id, $dst_file)) {
126        gfPrintLog("¥Õ¥¡¥¤¥ëºï½ü¤ËÀ®¸ù¤·¤Þ¤·¤¿¡£SERVER:" . $host . " " . $dst_file);
127    } else {
128        gfPrintLog("¥Õ¥¡¥¤¥ëºï½ü¤Ë¼ºÇÔ¤·¤Þ¤·¤¿¡£SERVER:" . $host . " " . $dst_file);
129    }
130   
131    // Àܳ¤òÊĤ¸¤ë
132    ftp_close($conn_id);
133}
134
135 /*
136 * ´Ø¿ô̾ ¡§sfFtpExist
137 * °ú¿ô1¡¡:FTP¥Û¥¹¥È
138 * $user:FTP¥æ¡¼¥¶
139 * $pass:FTP¥Ñ¥¹¥ï¡¼¥É
140 * $file_path:¥Õ¥¡¥¤¥ë¥Ñ¥¹
141 * Ìá¤êÃÍ¡§Â¸ºß¤·¤¿¤étrue̵¤«¤Ã¤¿¤éfalse¤òÊÖ¤¹
142 * ÀâÌÀ¡¡¡§FTP¤¹¤ë¥µ¡¼¥Ð¤Ë¥Õ¥¡¥¤¥ë¤¬Ìµ¤¤¤«Ä´ºº¤¹¤ë
143 */
144 function sfFtpExist($host, $user, $pass, $file_path) {
145
146    $conn_id = ftp_connect($host);
147    $login_result = ftp_login($conn_id, $user, $pass);
148    $res = ftp_size($conn_id, $file_path);
149
150    // Ìá¤êÃͤ¬-1¤Ê¤é¥Õ¥¡¥¤¥ë¤¬Â¸ºß¤·¤Ê¤¤
151    if($res == -1) {
152        return false;
153    }
154       
155    return true;
156}
157?>
Note: See TracBrowser for help on using the repository browser.