Diff of /xoonips/AL/commonal.cc

OSDN > Find Software > XooNIps

 Browse CVS Repository



/[OSDN]/xoonips/AL/commonal.cc




Diff of /xoonips/AL/commonal.cc



 Parent Directory

|  Revision Log


|  Revision Graph


|  Patch














revision 1.104 by aga4096,
Mon Aug 29 02:05:34 2005 UTC




revision 1.105 by aga4096,
Mon Aug 29 05:27:37 2005 UTC






#

Line 22 



Line 22 













22
  * 
  * 

















23
  * $Revision$
  * $Revision$

















24
  * $Log$
  * $Log$












25
 
  * Revision 1.105  2005/08/29 05:27:37  aga4096







26
 
  * ・update_item_statusの修正.







27
 
  *












28
  * Revision 1.104  2005/08/29 02:05:34  aga4096
  * Revision 1.104  2005/08/29 02:05:34  aga4096

















29
  * ・xnp_update_item_status(), xnp_refresh_item_status(), xnp_selective_harvesting() を追加.
  * ・xnp_update_item_status(), xnp_refresh_item_status(), xnp_selective_harvesting() を追加.

















30
  *
  *











#

Line 8212 
 result_t updateItemStatus()


Line 8215 
 result_t updateItemStatus()












8215
         }
         }

















8216
         {
         {

















8217
             // アイテムが非公開で、item_status.is_deleted=0のものを修正
             // アイテムが非公開で、item_status.is_deleted=0のものを修正















8218


             string sql = "select tis.item_id "


             string sql = "select tis.item_id, count(tx.index_id) as public_count "















8219
               " from "      + dbprefix + "_xoonips_item_status as tis  "
               " from "      + dbprefix + "_xoonips_item_status as tis  "

















8220
               " left join " + dbprefix + "_xoonips_index_item_link as tl on tl.item_id = tis.item_id and certify_state = " + unsignedIntToString(index::CERTIFIED) +
               " left join " + dbprefix + "_xoonips_index_item_link as tl on tl.item_id = tis.item_id and certify_state = " + unsignedIntToString(index::CERTIFIED) +

















8221
               " left join " + dbprefix + "_xoonips_index           as tx on tx.index_id =tl.index_id and tx.open_level = " + unsignedIntToString(index::OL_PUBLIC) + 
               " left join " + dbprefix + "_xoonips_index           as tx on tx.index_id =tl.index_id and tx.open_level = " + unsignedIntToString(index::OL_PUBLIC) + 















8222


               " where is_deleted=0 and tx.index_id is NULL ";


               " where is_deleted=0 group by tis.item_id having pubilc_count=0 ";















8223
             sqlexec_t s( "updateItemStatus", sql, &ret );
             sqlexec_t s( "updateItemStatus", sql, &ret );

















8224
             if ( s.getSqlcode() == SQL_SUCCESS ){
             if ( s.getSqlcode() == SQL_SUCCESS ){

















8225
                 SQLUINTEGER iid = 0;
                 SQLUINTEGER iid = 0;











#

Line 8252 
 result_t refreshItemStatus()


Line 8255 
 result_t refreshItemStatus()












8255
 }
 }

















8256
 
 

















8257
 /** selective harvesting
 /** selective harvesting















8258


  * @param from, until  選択範囲 


  * @param from, until  選択範囲   指定しない場合は0を入れる















8259
  * @param startIID     startIID<=item_idであるようなitem_idのみを得る
  * @param startIID     startIID<=item_idであるようなitem_idのみを得る

















8260
  * @param limit        返すitem_idの個数の上限
  * @param limit        返すitem_idの個数の上限

















8261
  * @param iids         item_idを返す配列  item_idの小さいものから配列に入る
  * @param iids         item_idを返す配列  item_idの小さいものから配列に入る





























Legend:



Removed from v.1.104
 


changed lines


 
Added in v.1.105













Back to OSDN">Back to OSDN
ViewVC Help


Powered by ViewVC 1.1.26
 /[OSDN]/xoonips/AL/commonal.cc
-revision 1.104 by aga4096,
Mon Aug 29 02:05:34 2005 UTC
+revision 1.105 by aga4096,
Mon Aug 29 05:27:37 2005 UTC
 Line 22
   *
   * $Revision$
   * $Log$
+  * Revision 1.105  2005/08/29 05:27:37  aga4096
+  * ・update_item_statusの修正.
+  *
   * Revision 1.104  2005/08/29 02:05:34  aga4096
   * ・xnp_update_item_status(), xnp_refresh_item_status(), xnp_selective_harvesting() を追加.
   *
-Line 8212 
 result_t updateItemStatus()
+Line 8215 
 result_t updateItemStatus()
          }
          {
              // アイテムが非公開で、item_status.is_deleted=0のものを修正
-             string sql = "select tis.item_id "
+             string sql = "select tis.item_id, count(tx.index_id) as public_count "
                " from "      + dbprefix + "_xoonips_item_status as tis  "
                " left join " + dbprefix + "_xoonips_index_item_link as tl on tl.item_id = tis.item_id and certify_state = " + unsignedIntToString(index::CERTIFIED) +
                " left join " + dbprefix + "_xoonips_index           as tx on tx.index_id =tl.index_id and tx.open_level = " + unsignedIntToString(index::OL_PUBLIC) +
-               " where is_deleted=0 and tx.index_id is NULL ";
+               " where is_deleted=0 group by tis.item_id having pubilc_count=0 ";
              sqlexec_t s( "updateItemStatus", sql, &ret );
              if ( s.getSqlcode() == SQL_SUCCESS ){
                  SQLUINTEGER iid = 0;
-Line 8252 
 result_t refreshItemStatus()
+Line 8255 
 result_t refreshItemStatus()
  }
  /** selective harvesting
-  * @param from, until  選択範囲
+  * @param from, until  選択範囲   指定しない場合は0を入れる
   * @param startIID     startIID<=item_idであるようなitem_idのみを得る
   * @param limit        返すitem_idの個数の上限
   * @param iids         item_idを返す配列  item_idの小さいものから配列に入る
 Legend:



Removed from v.1.104
 


changed lines


 
Added in v.1.105
 Legend:



Removed from v.1.104
 


changed lines


 
Added in v.1.105
-Removed from v.1.104
+Added in v.1.105
-Back to OSDN">Back to OSDN
+ViewVC Help
 Powered by ViewVC 1.1.26

Develop and Download Open Source Software

XooNIps

Browse CVS Repository