全部问题

有这样的js

$('a[href^="#"]').on('click', function (e) {
        e.preventDefault();
        var hrefAttr = $(this).attr("href");
        parent = $(this).closest("ul");
        parent.find("a").removeClass("active");
        $(this).addClass("active");
        if($(hrefAttr).length == 0) {
            location.href='/'+hrefAttr;
        } else {
            if( hrefAttr.length > 0 && hrefAttr != "#") {
                $('html, body').stop().animate({
                    'scrollTop': $(hrefAttr).offset().top-10
                }, 500);
            }
        }
    });

如果 $(hrefAttr) 元素丢失，则需要转到 location.href='/'+hrefAttr 并滚动到 $(hrefAttr)。滚动良好。但当你点击这个链接时

<a href="#" data-popup-link="callback">Заказать звонок</a>

给出一个错误

jquery.js?ver=1.0:1586 Uncaught Error: Syntax error, unrecognized expression: #

这就是该表格效果不佳的原因。

如何解决这个问题？

现在，我正在编写一个函数，该函数将清理 UI 中的列表 (ProjectsUpdate())（图 1）并将预制件中的新插槽加载到其中，但我面临的事实是，并非所有列表元素都是已删除。我开始一步步调试，发现当我删除列表的第一个元素时，再次输入foreach就会被跳过。如何确保列表正常清理？我附上了脚本和拓扑（图 1）。

using UnityEngine;
using System.IO;
using UnityEngine.UI;
using TMPro;
using System.Linq;

public class ProjectViewManager : MonoBehaviour
{
    [SerializeField] private Transform table;
    [SerializeField] private GameObject slotTemp;
    public void ProjectsUpdate()
    {
        print(table.childCount);
            if (table.childCount > 0)
            {
                foreach (Transform child in table) DestroyImmediate(child.gameObject);
            }
        var list = System.IO.Directory.GetFiles(Application.persistentDataPath);
        foreach (var file in list.ToList()) OpenJson(file);
    }
    public void SetTemp(string name,int cost,int duration)
    {
        GameObject temp = Instantiate(slotTemp,table);
        temp.transform.Find("name").GetComponent<TextMeshProUGUI>().text = name;
        temp.transform.Find("cost").GetComponent<TextMeshProUGUI>().text = "cost:"+cost.ToString();
        temp.transform.Find("duration").GetComponent<TextMeshProUGUI>().text = "duration:"+duration.ToString();
    }
    private void Start()
    {
        ProjectsUpdate();
    }

    public void OpenJson(string name)
    {
        string dataToLoad = "";
        string fullPath = Path.Combine(Application.persistentDataPath, name);
        FileStream stream = new FileStream(fullPath, FileMode.Open);
        StreamReader reader = new StreamReader(stream);
        dataToLoad = reader.ReadToEnd();
        ProjData data = JsonUtility.FromJson<ProjData>(dataToLoad);
        SetTemp(data.projName, data.cost, data.duration);
        reader.Close();
    }
}

有两个具有预定义名称的имя_класса.lower()+'s'表id: Mapped[int] = mapped_column(Integer, primary_key=True, autoincrement=True)

无法在两个表之间以及第一个表的记录之间创建多对多关系。

“构建”表：

class Assembly(Base):
    serial_number: Mapped[str_uniq] = mapped_column(String)
    name: Mapped[str] = mapped_column(String)
    link: Mapped[str] = mapped_column(String)
    deleted_at: Mapped[DateTime] = mapped_column(DateTime)

    # Связь с таблицей assemblyparts через backref
    parts: Mapped[list['Part']] = relationship(
        'Part',
        secondary='assemblyparts',
        back_populates='assemblys'
    )

    # Связь с другими сборками через backref
    child_assemblys: Mapped[list['Assembly']] = relationship(
        'Assembly',
        secondary='assemblycompositions',
        primaryjoin=id == column('parent_assembly_id'),
        secondaryjoin=id == column('child_assembly_id'),
        back_populates='parent_assemblys'
    )

    parent_assemblys: Mapped[list['Assembly']] = relationship(
        'Assembly',
        secondary='assemblycompositions',
        primaryjoin=id == column('child_assembly_id'),
        secondaryjoin=id == column('parent_assembly_id'),
        back_populates='child_assemblys'
    )

和“详细信息”：

class Part(Base):
    serial_number: Mapped[str_uniq] = mapped_column(String)
    name: Mapped[str] = mapped_column(String)
    link: Mapped[str] = mapped_column(String)
    deleted_at: Mapped[DateTime] = mapped_column(DateTime)

    # Связь с таблицей assembly_parts через backref
    assemblys: Mapped[list['Assembly']] = relationship(
        'Assembly',
        secondary='assemblyparts',
        back_populates='parts'
    )

还有关联表：

class AssemblyPart(Base):
    '''Ассоциативная таблица для связей между сборками и деталями'''
    assembly_id: Mapped[int] = mapped_column(ForeignKey('assemblys.id'), primary_key=True)
    part_id: Mapped[int] = mapped_column(ForeignKey('parts.id'), primary_key=True)
    quantity: Mapped[int] = mapped_column(Integer)


class AssemblyComposition(Base):
    '''Промежуточная таблица для связи many-to-many между сборками'''
    parent_assembly_id: Mapped[int] = mapped_column(ForeignKey('assemblys.id'))
    child_assembly_id: Mapped[int] = mapped_column(ForeignKey('assemblys.id'))
    quantity: Mapped[int] = mapped_column(Integer)
    # Составной первичный ключ
    __table_args__ = (
        PrimaryKeyConstraint('parent_assembly_id', 'child_assembly_id'),
)

对于装配和零件之间的多对多关系，使用AssemblyPart表- 每个零件可以是多个装配的一部分，并且每个装配可以包含多个零件。另外，每个组件可以包括其他组件并且其本身可以包括在其他组件中。

初始化表的时候出现错误：

sqlalchemy.exc.ArgumentError：无法在关系 Assembly.child_assembles 上找到主联接条件“parent_ assembly_id = :parent_ assembly_id_1”的任何相关外键列。

确保引用列与ForeignKey 或ForeignKeyConstraint 关联，或者在连接条件中使用foreign() 注释进行注释。

如果删除用于将程序集相互连接的关联表 ( AssemblyComposition ) 并从Assembly中删除它的参数，则表的初始化可以正常工作。那些。正确定义了零件和装配体之间的关系。

我做错了什么？

告诉我，是否可以使用 CSS 制作这样的遮罩，以便将来您可以插入任何照片？

有这样一个数据框：

       newbs longitudeY1 latitudeX1   oldbs       longitudeY2        latitudeX2     BSC   LAC
0     IR021  105.98790  52.78068  IR0505   104.2578286633  52.655474988944  396402  5244
1     IR021  105.98790  52.78068  IR1017  104.59863944009  52.384744395507  396402  5244
2     IR021  105.98790  52.78068  IR1020  104.14058703968  52.010800749578  396402  5307
3     IR021  105.98790  52.78068  IR1023  104.15358510877  52.719410098781  396402  5319
4     IR021  105.98790  52.78068  IR1030  104.20639053885  52.573995078092  396402  5244
...      ...         ...        ...     ...               ...               ...     ...   ...
4192  IR066  105.68000  54.34308  IR2964  103.24349640892  52.974271985462  401257  5272
4193  IR066  105.68000  54.34308  IR2965  105.67618886914  54.995100603944  401257  5251
4194  IR066  105.68000  54.34308  IR2969  103.47831487935  52.720066254791  401257  5259
4195  IR066  105.68000  54.34308  IR2970  103.72418234894   52.09637656718  401257  5272
4196  IR066  105.68000  54.34308  IR2981  103.85440774559  52.517154218339  401257  5272

如何在此表中应用公式 sqrt((x1-x2) * (x1-x2) + (y1-y2) * (y1-y2)) ？在我的代码中它抱怨错误：

Traceback (most recent call last):
  File "P:\projects\FillingInDataForTheSite\py.py", line 308, in <module>
    newNeighbourTable["distance"] = math.sqrt((x1-x2) * (x1-x2) + (y1-y2) * (y1-y2))        
  File "C:\Users\david\AppData\Roaming\Python\Python310\site-packages\pandas\core\series.py", line 248, in wrapper
    raise TypeError(f"cannot convert the series to {converter}")
TypeError: cannot convert the series to <class 'float'>

这是我的代码，在评论中这些是我解决问题的尝试：

        newNeighbourTable = newdatatable.merge(olddatatable, how='cross')        
        print(" - Добавляю общую таблицу.")
        x1=newNeighbourTable["latitudeX1"].astype(float)
        x2=newNeighbourTable["latitudeX2"].astype(float)
        y1=newNeighbourTable["longitudeY1"].astype(float)
        y2=newNeighbourTable["longitudeY2"].astype(float)
        #newNeighbourTable["distance"] = ""
        newNeighbourTable["distance"] = math.sqrt((x1-x2) * (x1-x2) + (y1-y2) * (y1-y2))        
        #for i, row in newNeighbourTable.iterrows():
        #    print(ewNeighbourTable.loc[i])
            #df_index = newNeighbourTable.loc[i]
            #results = math.sqrt((x1-x2) * (x1-x2) + (y1-y2) * (y1-y2))
            #newNeighbourTable["distance"] = results
        print(newNeighbourTable)
        print(newNeighbourTable.dtypes)