WordPress.org
Get WordPress

Plugin Directory

Changeset 2619863


Ignore:
Timestamp:
10/26/2021 06:06:26 AM (4 years ago)
Author:
mbmipak
Message:

ver 2.0.5

Location:
mbm-ipak/trunk
Files:
3 edited

Legend:

Unmodified
Added
Removed

  • mbm-ipak/trunk/include/sql_scripts.php

    r2619854 r2619863  
    1414              )ENGINE=InnoDB $charset_collate; ";
    1515
    16     $sql .= "INSERT INTO $table_name(id,type_id,title) select '-1','1','بانک ووکامرس' where not exists(select * from $table_name where id = '-1');  ";
    17     $sql .= "INSERT INTO $table_name(id,type_id,title) select '-2','4','فروش محصولات ووکامرس' where not exists(select * from $table_name where id = '-2');  ";
    18     $sql .= "INSERT INTO $table_name(id,type_id,title) select '-3','2',' مشتری ووکامرس' where not exists(select * from $table_name where id = '-3');  ";
     16    $sql .= "INSERT INTO $table_name(id,type_id,title) VALUES('-1','1','بانک ووکامرس') ON DUPLICATE KEY UPDATE type_id = '1';  ";
     17    $sql .= "INSERT INTO $table_name(id,type_id,title) VALUES('-2','4','فروش محصولات ووکامرس') ON DUPLICATE KEY UPDATE type_id = '4';  ";
     18    $sql .= "INSERT INTO $table_name(id,type_id,title) VALUES('-3','2','مشتری ووکامرس') ON DUPLICATE KEY UPDATE type_id = '2';  ";
    1919
    2020    $table_name = $wpdb->prefix . "hesab_model_type";
    … …  
    2626                  )ENGINE=InnoDB $charset_collate; ";
    2727
    28     $sql .= "INSERT INTO $table_name(id,title,title_fa) select '1','bank','بانک' where not exists(select * from $table_name where title = 'bank');  ";
    29     $sql .= "INSERT INTO $table_name(id,title,title_fa) select '2','contact','طرف حساب' where not exists(select * from $table_name where title = 'contact');  ";
    30     $sql .= "INSERT INTO $table_name(id,title,title_fa) select '3','cost','هزینه' where not exists(select * from $table_name where title = 'cost');  ";
    31     $sql .= "INSERT INTO $table_name(id,title,title_fa) select '4','income','درآمد' where not exists(select * from $table_name where title = 'income');  ";
    32     $sql .= "INSERT INTO $table_name(id,title,title_fa) select '5','insert_cost','ثبت هزینه' where not exists(select * from $table_name where title = 'insert_cost');  ";
    33     $sql .= "INSERT INTO $table_name(id,title,title_fa) select '6','insert_income','ثبت درآمد' where not exists(select * from $table_name where title = 'insert_income');  ";
    34     $sql .= "INSERT INTO $table_name(id,title,title_fa) select '7','insert_debt','ثبت بدهکار' where not exists(select * from $table_name where title = 'insert_debt');  ";
    35     $sql .= "INSERT INTO $table_name(id,title,title_fa) select '8','insert_demand','ثبت طلبکار' where not exists(select * from $table_name where title = 'insert_demand');  ";
    36     $sql .= "INSERT INTO $table_name(id,title,title_fa) select '9','insert_pay','پرداخت نقدی' where not exists(select * from $table_name where title = 'insert_pay');  ";
    37     $sql .= "INSERT INTO $table_name(id,title,title_fa) select '10','insert_cash','دریافت نقدی' where not exists(select * from $table_name where title = 'insert_cash');  ";
    38     $sql .= "INSERT INTO $table_name(id,title,title_fa) select '11','report_cost',' گزارش هزینه' where not exists(select * from $table_name where title = 'report_cost');  ";
    39     $sql .= "INSERT INTO $table_name(id,title,title_fa) select '12','report_cost',' گزارش درآمد' where not exists(select * from $table_name where title = 'report_cost');  ";
    40     $sql .= "INSERT INTO $table_name(id,title,title_fa) select '13','report_cost',' گزارش بدهکاران و طلبکاران' where not exists(select * from $table_name where title = 'report_cost');  ";
    41     $sql .= "INSERT INTO $table_name(id,title,title_fa) select '14','report_cost',' گزارش   موجودی بانک' where not exists(select * from $table_name where title = 'report_bank');  ";
     28    $sql .= "INSERT INTO $table_name(id,title,title_fa) VALUES('1','bank','بانک') ON DUPLICATE KEY UPDATE title = 'bank';  ";
     29    $sql .= "INSERT INTO $table_name(id,title,title_fa) VALUES('2','contact','طرف حساب') ON DUPLICATE KEY UPDATE title = 'contact';  ";
     30    $sql .= "INSERT INTO $table_name(id,title,title_fa) VALUES('3','cost','هزینه') ON DUPLICATE KEY UPDATE title = 'cost';  ";
     31    $sql .= "INSERT INTO $table_name(id,title,title_fa) VALUES('4','income','درآمد') ON DUPLICATE KEY UPDATE title = 'income';  ";
     32    $sql .= "INSERT INTO $table_name(id,title,title_fa) VALUES('5','insert_cost','ثبت هزینه') ON DUPLICATE KEY UPDATE title = 'insert_cost';  ";
     33    $sql .= "INSERT INTO $table_name(id,title,title_fa) VALUES('6','insert_income','ثبت درآمد') ON DUPLICATE KEY UPDATE title = 'insert_income';  ";
     34    $sql .= "INSERT INTO $table_name(id,title,title_fa) VALUES ('7','insert_debt','ثبت بدهکار') ON DUPLICATE KEY UPDATE title = 'insert_debt';  ";
     35    $sql .= "INSERT INTO $table_name(id,title,title_fa) VALUES ('8','insert_demand','ثبت طلبکار') ON DUPLICATE KEY UPDATE title = 'insert_demand';  ";
     36    $sql .= "INSERT INTO $table_name(id,title,title_fa) VALUES ('9','insert_pay','پرداخت نقدی') ON DUPLICATE KEY UPDATE title = 'insert_pay';  ";
     37    $sql .= "INSERT INTO $table_name(id,title,title_fa) VALUES ('10','insert_cash','دریافت نقدی') ON DUPLICATE KEY UPDATE title = 'insert_cash';  ";
     38    $sql .= "INSERT INTO $table_name(id,title,title_fa) VALUES ('11','report_cost',' گزارش هزینه') ON DUPLICATE KEY UPDATE title = 'report_cost';  ";
     39    $sql .= "INSERT INTO $table_name(id,title,title_fa) VALUES ('12','report_cost',' گزارش درآمد') ON DUPLICATE KEY UPDATE title = 'report_cost';  ";
     40    $sql .= "INSERT INTO $table_name(id,title,title_fa) VALUES ('13','report_cost',' گزارش بدهکاران و طلبکاران') ON DUPLICATE KEY UPDATE title = 'report_cost';  ";
     41    $sql .= "INSERT INTO $table_name(id,title,title_fa) VALUES ('14','report_cost',' گزارش   موجودی بانک') ON DUPLICATE KEY UPDATE title = 'report_bank';  ";
    4242
    4343

  • mbm-ipak/trunk/mbm-ipak.php

    r2619847 r2619863  
    88 *
    99 * @link              http://mbmti.ir
    10  * @since             2.0.5
     10 * @since             2.0.6
    1111 * @package           MBM_IPAK
    1212 *
    … …  
    1515 * Plugin URI:        http://mbmti.ir
    1616 * Description:       سیستم حسابداری ایپک
    17  * Version:           2.0.5
     17 * Version:           2.0.6
    1818 * Author:            ایپک
    1919 * Author URI:        http://mbmti.ir/our-team
    … …  
    2727/* General Definition
    2828******************************/
    29 define('MBM_IPAK_VERSION', '2.0.5');
     29define('MBM_IPAK_VERSION', '2.0.6');
    3030
    3131define('MBM_IPAK_BASE', plugin_dir_path(__FILE__));

  • mbm-ipak/trunk/readme.txt

    r2619847 r2619863  
    55Requires at least: 3.0.1
    66Tested up to: 5.8.1
    7 Stable tag: 2.0.5
     7Stable tag: 2.0.6
    88License: GPLv2 or later
    99License URI: http://www.gnu.org/licenses/gpl-2.0.html
Note: See TracChangeset for help on using the changeset viewer.